Email Alerts
-
Oracle updates Microsoft developer tools
Oracle is offering free tools for Microsoft .NET and ASP.NET applications developers running the Oracle Database 10g. Article | 14 Jun 2007
-
Oracle updates free Web development tool
Oracle Application Express now offers Microsoft Access migration and .pdf printing support. Article | 26 Mar 2007
-
Oracle SQL Developer gets an update
Oracle says its newly updated SQL Developer tool includes enhancements that make it easier to create and debug SQL and PL/SQL code. Article | 08 Jan 2007
-
ANTs hoping to ruin Oracle's picnic
An executive for ANTs Software Inc. makes a case for his firm's namesake data server over Oracle and other leading database management systems. Article | 19 Sep 2006
-
Oracle updates free Application Express developer tool
The newest version of Oracle Application Express promises to make it easier for companies to build applications on top of Database 10g, and one communications software firm is banking on it. Article | 31 Aug 2006
-
Oracle unveils new tools for .NET developers
Oracle has unveiled two new free downloads for developers of Microsoft .NET applications who want to get more out of Database 10g. Article | 01 Aug 2006
-
Mike Ault's Oracle "good practices": Oracle coding
Mike Ault offers "good practices" for Oracle coding, including using array processing, placing code within stored procedures and using proper variable types for variable declaration. Tip
-
Lessons learned: Integrating Oracle and SQL Server
Whether you're trying to execute an Oracle stored procedure on SQL Server or move data from one DBMS to another, you'll find troubleshooting advice in this collection of short lessons by Kevin Kline, our resident SQL Server Monitoring/Administration ... Tip
-
SQL generation vs. Oracle stored procedures
An ITKnowledge Exchange member had a question about which option to choose: SQL generation or stored procedures. Fellow Oracle techies helped Steve. Tip
-
PL/SQL control structures: Best practices
Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in PL/SQL. Tip
-
Accessing non-Oracle databases using stored procedures and JDBC
This tip demonstrates how to connect to non-Oracle databases from within Oracle stored procedures using JDBC. Tip
-
Using Java stored procedures: AOL instant messaging from Oracle
Have you been wondering how you might use Java stored procedures instead of Oracle's native PL/SQL stored procedures? Tip
-
A stored procedure to send email
A stored procedure to send an email message using the Oracle utl_smtp package. Tip
-
Using INITCAP in Oracle and SQL Server
A well-annotated stored procedure showing how to use the Oracle funciton INITCAP in both Oracle and SQL Server. Tip
-
Calling Java stored procedures from triggers
Coupling triggers and Java-stored procedures can facilitate constraint or application requirements. Tip
-
How to use a stored procedure to fetch from ref cursor in Oracle
Oracle expert Dan Clamage explains how to use a stored procedure to fetch from a ref cursor in Oracle in this tip. Answer
-
How do you create a link between two databases inside a stored procedure?
An Oracle user asks how to create a link between two databases inside a stored procedure. Ask the Expert
-
Stored procedure to autotransfer data between Oracle servers
How to make a stored procedure to autotransfer updated data from a remote server to a central server? Ask the Expert
-
Insufficient privileges error when creating stored procedure
I need to create a stored procedure in my schema using Toad but it gives me the error "Insufficient privileges." Ask the Expert
-
ORA-01422 error when procedure returns more than one row
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. Ask the Expert
-
Calling procedure inside another procedure in anonymous block
I have a procedure p1 which holds another procedure p2. I want to call this p2 procedure in an anonymous block. Ask the Expert
-
Can I make a second connection to Oracle without losing the first?
Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection? Ask the Expert
-
How to create an index using a procedure in Oracle
How can we create an index using a procedure? Ask the Expert
-
Procedure compiles but does not execute
When I create a table using an execute immediate statement in the procedure, the procedure will compile but is not executed. Why? Ask the Expert
-
Tool in Oracle 10g to keep track of execution of queries
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? Ask the Expert
- See more Expert Advice on Oracle stored procedures
-
stored procedure
In a database management system (DBMS), a stored procedure is a precompiled set of Structured Query Language (SQL) statements that can be shared by a number of programs. (Continued...) Definition
-
How to use a stored procedure to fetch from ref cursor in Oracle
Oracle expert Dan Clamage explains how to use a stored procedure to fetch from a ref cursor in Oracle in this tip. Answer
-
How do you create a link between two databases inside a stored procedure?
An Oracle user asks how to create a link between two databases inside a stored procedure. Ask the Expert
-
Stored procedure to autotransfer data between Oracle servers
How to make a stored procedure to autotransfer updated data from a remote server to a central server? Ask the Expert
-
Insufficient privileges error when creating stored procedure
I need to create a stored procedure in my schema using Toad but it gives me the error "Insufficient privileges." Ask the Expert
-
ORA-01422 error when procedure returns more than one row
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. Ask the Expert
-
Calling procedure inside another procedure in anonymous block
I have a procedure p1 which holds another procedure p2. I want to call this p2 procedure in an anonymous block. Ask the Expert
-
Can I make a second connection to Oracle without losing the first?
Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection? Ask the Expert
-
How to create an index using a procedure in Oracle
How can we create an index using a procedure? Ask the Expert
-
Oracle updates Microsoft developer tools
Oracle is offering free tools for Microsoft .NET and ASP.NET applications developers running the Oracle Database 10g. Article
-
Procedure compiles but does not execute
When I create a table using an execute immediate statement in the procedure, the procedure will compile but is not executed. Why? Ask the Expert
- See more All on Oracle stored procedures
About Oracle stored procedures
Learn more about using stored procedures, subroutines available to applications accessing the database, in Oracle. Browse our large collection of tips, tutorials, scripts and expert answers to technical questions.