Oracle stored procedures news, help and research


	Oracle stored procedures


	Home > Oracle Topics > Oracle development languages > Oracle stored procedures > Expert Technical Advice

Oracle Topics:

EMAIL THIS

TOPICS HOME

BROWSE ALL ORACLE TOPICS

ORACLE INFO CENTERS

RESOURCE CENTERS

RSS FEEDS


Oracle stored procedures



IN THIS TOPIC:	NEWS (11) , EXPERT TECHNICAL ADVICE (78) , BEST WEB LINKS (3) , DEFINITIONS (1)

Display in sets of:


1 - 10 of 78 in Expert Technical Advice		<< Previous page 1 2 3 ... 6 7 8 Next >>


	Stored procedure to autotransfer data between Oracle servers 15 Aug 2007 EXPERT ANSWER - How to make a stored procedure to autotransfer updated data from a remote server to a central server?


	Insufficient privileges error when creating stored procedure 18 Jul 2007 EXPERT ANSWER - I need to create a stored procedure in my schema using Toad but it gives me the error "Insufficient privileges."


	ORA-01422 error when procedure returns more than one row 13 Jul 2007 EXPERT ANSWER - I have the following Oracle procedure that returns one or more rows depending upon the input into the SQL statement. When there is greater than one row returned I get the ORA-01422 error.


	Can I make a second connection to Oracle without losing the first? 11 Jul 2007 EXPERT ANSWER - Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection?


	Calling procedure inside another procedure in anonymous block 11 Jul 2007 EXPERT ANSWER - I have a procedure p1 which holds another procedure p2. I want to call this p2 procedure in an anonymous block.


	How to create an index using a procedure in Oracle 21 Jun 2007 EXPERT ANSWER - How can we create an index using a procedure?


	Procedure compiles but does not execute 06 Jun 2007 EXPERT ANSWER - When I create a table using an execute immediate statement in the procedure, the procedure will compile but is not executed. Why?


	Tool in Oracle 10g to keep track of execution of queries 23 May 2007 EXPERT ANSWER - How can I keep track of the execution of stored procedures, functions and queries in Oracle 10g, as I used to do using SQL Server Profiler? Is there any tool in 10g for this purpose?


	Execute SQL statement from table in other schema 02 Apr 2007 EXPERT ANSWER - I want to execute SQL statements that use other schema tables from my stored procedure. The stored procedure is in one schema and the table is in the other schema. I am getting the "ORA-01031: insufficient privileges" error.


	ORA-04082: NEW or OLD references not allowed in table level triggers 02 Apr 2007 EXPERT ANSWER - I am calling a stored procedure from a trigger. It shows the error: "ORA-04082: NEW or OLD references not allowed in table level triggers."


1 - 10 of 78 in Expert Technical Advice		<< Previous page 1 2 3 ... 6 7 8 Next >>

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy