Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

where are plsql stored procedres stored?

Status
Not open for further replies.
jfdabiri

jfdabiri

MIS
Feb 27, 2007
282
US
hi, i have this code (vbscript/asp) that refers to a stored procedure. my question is, where are stored procedures stored in oracle?
Code: 
objCmd.Properties("PLSQLRSet") = TRUE
objCmd.CommandText = "oms_owner.pk_popcount.getinsttotals"
Set objSearch = objCmd.Execute
 
Sort by date Sort by votes
That depends. Are you talking about the text of the code? If so, you can find this in the user|all|dba _source data dictionary tables. If you are talking about the compile m-code of the proc, this is transparent and you don't really need to know, if you are talking about interpreted compilation of code, these are stored on the OS in C libraries.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
sa0309
  • Locked
  • Question
Case expression in the WHERE clause of a delete statment
Replies
2
Views
161
carp
carp
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
209
fredericofonseca
fredericofonseca
szeiss
  • Locked
  • Question
Updating 1 Record When There Are Duplicates
Replies
4
Views
171
szeiss
szeiss
IanWaterman
  • Locked
  • Question
Executing Stored Proc.
Replies
1
Views
110
IanWaterman
IanWaterman

Part and Inventory Search

Sponsor

Back
Top