Swadhin Ray
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER