Calling a procedure inside another

How to call a procedure p1 inside p2?

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

How to call a procedure p1 inside p2?

Calling a procedure inside another procedure is as simple as just stating the procedure. In the example below, I show how to simply call P1. I then call P1 and pass two parameters to it as well.

CREATE PROCEDURE p2
AS
BEGIN
   p1;
   p1(parm1,parm2);
END;
/

This was last published in September 2006

Dig Deeper on Oracle database design and architecture

All
News
Get Started
Evaluate
Manage
Problem Solve

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

11 real-time data streaming roadblocks and how to overcome them

Experts detail common challenges that IT teams encounter when deploying and managing real-time data streaming platforms and offer...

Snowflake product VP expounds on data warehouse for the cloud

In this Q&A, Christian Kleinerman, vice president of product development at cloud data warehouse vendor Snowflake, talks about ...

RavenDB Cloud automates database management

RavenDB's managed cloud database service, RavenDB Cloud, intends to automate security processes, reduce overhead and cater to ...

SearchBusinessAnalytics

Updated AtScale platform streamlines analysis of big data

By improving the machine learning and augmented intelligence capabilities of its platform, AtScale's newest release attempts to ...

ThoughtSpot strategic partnerships help add capabilities

Through its partnership strategy, ThoughtSpot is adding to its capabilities as a BI software vendor the same way others are ...

IBM battling to change perception of Cognos Analytics BI platform

While some see IBM's BI suite as being too complicated and expensive for citizen data scientists, the company is adding updates ...

SearchSAP

As SaaS ERP, S/4HANA Cloud not meant to replicate ECC

In a Q&A, Jan Gilg, SAP's new global head of S/4HANA, joined SVP Sven Denecken to explain the differences between the on-premises...

SAP Leonardo technologies seek to empower the digital enterprise

Learn the fundamentals of Leonardo, how it has evolved over the years and key steps to using its advanced technologies to build a...

SAP PartnerEdge initiative offers free S/4HANA Cloud resources

SAP now offers free access to S/4HANA and C/4HANA test and demonstration systems to qualified partners. The new partner program ...

SearchSQLServer

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

How SQL Server DevOps processes help break down data silos

DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos ...

Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database ...

TheServerSide.com

Weigh cost, flexibility in your Java cloud IDE comparisons

What's in a cloud IDE for Java developers? Flexibility and integration for starters. Consider these four options in your ...

What are the differences between EAR, JAR and WAR files?

JAR, WAR and EAR files provide options in a Java application deployment. Let's compare these file types and determine which one ...

4 great Java-based CMS options

Open source Java CMS tools come in a wide variety of shapes and sizes. Explore these four platforms to see if they would be a ...

SearchDataCenter

3 ways to benefit from open source infrastructure

Using open source infrastructure can reduce operating costs and streamline upgrades, but it's important to weigh the pros and ...

IBM mainframes face competitive pressures inside and out

IBM's mainframe business continues to be under pressure from cloud-based competitors, and perhaps even its own Power server. ...

Linux features beyond server management

Due to its open source nature, Linux is constantly gaining new capabilities. Here's a look at some common use cases and features.

SearchContentManagement

Alfresco cloud migration service moves content off premises

With new cloud migration services, Alfresco promises to move content from IBM, SharePoint, Documentum and other legacy ECM ...

Using AI in content creation can streamline publishing

Companies using AI in content creation can generate short-form material automatically, which frees up humans to handle more ...

New Contentful CMS targets content delivery for retailers

Contentful's content infrastructure is a CMS that intends to bring more flexibility and benefits than a traditional or headless ...

SearchHRSoftware

Eliminating bias in AI is no easy feat, but fixes do exist

As more companies turn to AI to reduce workplace and recruiting bias, it is important to be aware that the data AI tools draw ...

Immigrant visa reform poised to complicate hiring plans

Legislators plan to act on a bill that will remove per-country caps for immigrant workers, making it more difficult for companies...

Continuous performance management comes with benefits, drawbacks

Many companies are ditching yearly performance reviews in favor of continuous performance management. The new method has its ...

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.