CODEWITHSUNDEEP
oracle-databasestored-procedures
lowLatency
lowLatency

Reputation: 5654

Calling one stored procedure from another in Oracle

In Oracle database,

Suppose there are two stored procedures
and stored procedure sp1 is calling another stored procedure sp2

The question is:

Will the called sp2 be able to access the sp1's temp table?

Upvotes: 3

Views: 1311

Answers (1)

Vasily Komarov
Vasily Komarov

Reputation: 1415

I suppose your mean: There is tmp table in database, sp1 filling the table, will be able sp2 to access (read or change) this data?

Yes it will. (If sp1 don't have "commit" before sp2 calling, of course).

Oracle Temporary Tables are used to store data for the duration of session or transaction. Sp1 and sp2 both working in same session.

Upvotes: 4

Related Questions