Home » SQL & PL/SQL » SQL & PL/SQL » RETURNING CLAUSE
RETURNING CLAUSE [message #39953] Tue, 27 August 2002 20:45 Go to next message
msh
Messages: 11
Registered: July 2002
Junior Member
Hi All,
I want to make use of Returning clause for retutning em Multiple values. Its saying we have to make use of some OCI callbacks . Can anybody give me the stuff how to return multiple values and print it on the screen same way like it will work for one return value.

Thanks
./mk

Report message to a moderator

Re: RETURNING CLAUSE [message #39955 is a reply to message #39953] Tue, 27 August 2002 21:51 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
insert into t (col_b) values (:b)
  returning col_a, col_c into :ra, :rc;

Report message to a moderator

Previous Topic: minus operator
Next Topic: CONVERSION.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 19:47:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.