writting PL/SQL procedures in designer
229641Feb 5 2003 — edited Feb 27 2003I 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