DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: CURSOR AND INPUT VARIABLE

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Unhappy

    hi
    i want to concat my IN variable inval to a CURSOR

    the value of the inval will be ' select * from emp where deptno = 10 '

    i will this inval to concat with the CURSOR @ the declaration part

    create or replace procedure test_formstr(inval in varchar2,outval out varchar2) as
    a varcahr2(100);
    cursor c1 is inval;
    begin
    dbms_output.put_line(a);
    valoutab := 1;
    end;

    is this POSSIBLE?
    plsss
    write back @ balajiyes@yahoo.com or jegannathans@yahoo.com
    jegan
    Cheers!
    OraKid.

  2. #2
    Join Date
    Apr 2001
    Posts
    24
    Please go and check Oracle Developer, some body has already given you your required answer.

  3. #3
    Join Date
    Aug 2000
    Location
    Ny
    Posts
    105
    Look into ref cursors

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width