Link to home
Start Free TrialLog in
Avatar of Swadhin Ray
Swadhin RayFlag for United States of America

asked on

Making a package and calling API to one PLSQL Block

Hello Experts,

I have a package which have two procedures. Finally i use a simple PLSQL block to call the package so that it calls the package.

the flow is like :

PLSQL Block --> Package.first_proceudre --> internally calls the second_procedure .

And finally the second procedure inserts the data into a temp table.

Attached here with the package which includes two procedure , the PLSQL block which is calling the package and finally the temp table structure.

I want to make this package and my block into one block , means I dont have to use any package any more .  What ever the package is doing just to put them into one block and from the main plsql block it should call like the second block, and finally should insert the records.

Can any one help me in achieving this process.
API.txt
package.sql
Temp-table.txt
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Swadhin Ray

ASKER

thanks...