Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a procedures in a package

900163Jun 19 2014 — edited Jun 19 2014

Hi,

I need some help in calling a procedures inside a package.

I have a package ABC in which I have 3 procedures X Y and Z. I need to call procedure Y from procedure X which belongs to same package.

Thanks in advance

This post has been answered by unknown-7404 on Jun 19 2014
Jump to Answer

Comments

unknown-7404
Answer
I have a package ABC in which I have 3 procedures X Y and Z. I need to call procedure Y from procedure X which belongs to same package.

This forum, as the title says, is for Sql Developer questions only and NOT for SQL or PL/SQL questions.

If this isn't related to Sql Developer then please mark it ANSWERED and repost it in the SQL and PL/SQL forum

https://community.oracle.com/community/developer/english/oracle_database/sql_and_pl_sql

When you post there you should provide your database name and full version.

You also need to explain why you even need help since procedure X can just call procedure Y directly since they are in the same package.

For an Oracle DB see the documentation and examples in 'Using PL/SQL Packages' in the PL/SQL Language doc

http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/packages.htm#CIHIJECJ

Marked as Answer by 900163 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2014
Added on Jun 19 2014
1 comment
912 views