Calling one stored procedure from another in Oracle

Question

In Oracle Database

Suppose there are two stored procedures
and the stored procedure sp1calls another stored proceduresp2

The question arises:

Will the caller sp2have access to the table sp1's temp?

+3

Java geek Apr 17 '12 at 5:04

1 answer

Vasily Komarov · Accepted Answer · 2012-04-17T05:27:03+0000

I assume that you mean: there is a tmp table in the database, sp1 populates the table, can sp2 access (read or modify) this data?

Yes it will. (If sp1 does not have a "commit" before invoking sp2, of course).

Oracle temporary tables are used to store data for the duration of a session or transaction. Sp1 and sp2 working in the same session.