How to get a returned multiple values from procedure by using cursor

Showing Answers 1 - 1 of 1 Answers

devi123

Sep 25th, 2007

Declare the collection variable (varrys or PL/SQL tables) as out parameter for the procedure and fetch the result set into collection variable.

Over vs runs -- same sequence number for each group
Adding delimiters to a file which has no delimiter
Data from 1 column to be separated in multiple columns
Procedure vs function
Use of nocopy in procedure
Output of m_dump - select only first 2 columns data
Email address as user name field validation
Sorting alphanumeric values
Single row converted into multiple rows using transformer stage
Oracle PL/SQL priVATe procedure

Rdbms
Cursor for loop and open, fetch,close
Vbscript sub procedure
Drop a table and its child tables from a database using procedure
Convert any two numbers into words and perform arithmetic operation
Create package body with one priVATe subprogram only without package specification
Update a table using multiple join conditions
Procedure memory and location
Import complete coloumn values to excel
Installation of os for more than one machine

It looks like you are using an AD Blocker!

Please Turn OFF your ad blocker

- OR -

Disable
Ad Blocker

Learn More

Create your
GeekInterview account

Signup

Continue Reading after Disabling

Refresh

How to get a returned multiple values from procedure by using cursor

devi123

Give your answer:

Related Answered Questions

Related Open Questions

Latest News

It looks like you are using an AD Blocker!

Login

How to get a returned multiple values from procedure by using cursor

devi123

Give your answer:

Related Answered Questions

Related Open Questions

Latest News

It looks like you are using an AD Blocker!