Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

writting PL/SQL procedures in designer

229641Feb 5 2003 — edited Feb 27 2003
I am writing stored procedures and triggers in designer6i. I clicked the syntax icon. I have had no problems with creating trigger but with procedures/functions the syntax tells me I have to declare tables and variables and exceptions that are already in designer. The variables and exceptions I have already declared in the dialogues I stepped through to create the procedure/trigger in the first place e.g.:

PLS-00201: (Line 7) identifier 'USERS' must be declared
PL/SQL: (Line 6) SQL Statement ignored


'USERS' is a table already created.

WHERE AM I GOING WRONG!! I AM CONFUSED.

THANKS FOR ALL HELP.

Hannah

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2003
Added on Feb 5 2003
#designer
10 comments
257 views