From: beny 18241 <beny18241@...>
Date: 2009-09-21T23:30:28+09:00
Subject: ruby-oci8 function

Hi,

I have few oracle functions for example:


-----
create or replace FUNCTION FUNCTION1(p_ID test.name% TYPE)
RETURN VARCHAR2 is result VARCHAR2(5);
BEGIN
    SELECT name || number into result from Test where name = p_id;
  RETURN result;
END FUNCTION1;
------

i have ruby-oci8 (2.0.2).

I wanted to write script which call this function.


-----
#!/usr/bin/ruby
require 'oci8'

OCI8.new("user", "password", '//localhost/xe').exec("DECLARE
  P_ID VARCHAR2(4000);
  v_Return VARCHAR2(200);
BEGIN
  P_ID := 'my value';

  v_Return := FUNCTION1(
    P_ID => P_ID
  );
  DBMS_OUTPUT.PUT_LINE('v_Return = ' || v_Return);
END;
")do |r| puts r.join(",");end
------


which dont work as i wanted any idea how make such a script ?


Please help
beny18241
-- 
Posted via http://www.ruby-forum.com/.