Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> cursor name

cursor name

From: michael <mxa_at_yahoo.com>
Date: 3 Jul 2004 12:42:04 -0700
Message-ID: <57e25f29.0407031142.16ff7d54@posting.google.com>


Hi,

is there anyway to retried cursor element's name ?

 if ord_dtl has 3 elements a,b and c then

if wish to print

a=1234
b=xyx
c=sssss
-----------------

a=577
...

for myrec in ( select * from ord_dtl )loop   dbms_Output.put_line(myrec%element || ' = ' .. ); end loop;

perl has a DBI function to do that , but I am trying to do it in pl/slq.

thanks
Michael Received on Sat Jul 03 2004 - 14:42:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US