Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 11, 2013 03:13 AM by april_123456
Member
375 Points
1033 Posts
Jan 05, 2013 03:56 PM|LINK
how can i select record from database table and put the data into temp. table in Oracle's package.
and select record from this temp table into output list. (temp table i need to create in stored procedure)
any example for my reference?
Contributor
3736 Points
727 Posts
Jan 06, 2013 08:32 PM|LINK
forget the TEMP table.. bad practice
use REF CURSOR to output your result set
Participant
775 Points
246 Posts
Jan 11, 2013 03:13 AM|LINK
Hello there,
With regards to your question, please view thge following:
http://docs.oracle.com/cd/E14072_01/server.112/e10595/tables003.htm
http://docs.oracle.com/cd/E15645_01/pt850pbr0/eng/psbooks/tape/chapter.htm?File=tape/htm/tape10.htm
Although, there may be a much more elegant way in approaching this question.
Hope this helps!
Best of Luck!
With Kind Regards,
-_-
Member
375 Points
1033 Posts
oracle package
Jan 05, 2013 03:56 PM|LINK
how can i select record from database table and put the data into temp. table in Oracle's package.
and select record from this temp table into output list. (temp table i need to create in stored procedure)
any example for my reference?
Lannie
Contributor
3736 Points
727 Posts
Re: oracle package
Jan 06, 2013 08:32 PM|LINK
forget the TEMP table.. bad practice
use REF CURSOR to output your result set
april_123456
Participant
775 Points
246 Posts
Re: oracle package
Jan 11, 2013 03:13 AM|LINK
Hello there,
With regards to your question, please view thge following:
http://docs.oracle.com/cd/E14072_01/server.112/e10595/tables003.htm
http://docs.oracle.com/cd/E15645_01/pt850pbr0/eng/psbooks/tape/chapter.htm?File=tape/htm/tape10.htm
Although, there may be a much more elegant way in approaching this question.
Hope this helps!
Best of Luck!
With Kind Regards,