From: beny 18241 <beny18241@...>
Date: 2009-09-22T18:46:00+09:00
Subject: Re: ruby-oci8 function

Hi,

its workiong when i run this way


SET SERVEROUTPUT ON
  DECLARE
    VQPN VARCHAR(200);
    VQPV VARCHAR2(1024);
    VC types.ref_cursor;
      BEGIN
        VQPN := 'MY_NAME';
        VQPV := 'MY_SUM';

      VC := get_devices_f(
      name  => VQPN,
      sum => VQPV);

  DBMS_OUTPUT.PUT_LINE(vqpn || vqpv);
END;


please help


krzysztof cierpisz wrote:
> On Sep 22, 9:33�am, beny 18241 <beny18...@gmail.com> wrote:
>>
>> stmt.c:539:in oci8lib.so: ORA-06550: line 2, column 12: (OCIError)
>> /var/lib/gems/1.8/gems/ruby-plsql-0.3.1/lib/plsql/procedure.rb:186:in
>>
>>
>> -----
>>
> 
> does this work when you're logged into your database?
> 
> select get_names_f('value1' , 'value2') from dual;
> 
> if yes please paste the full function creation statement
> 
> chris

-- 
Posted via http://www.ruby-forum.com/.