Stack Overflow
Stack Overflow

Questions tagged [pls-00201]

an Oracle PL/SQL error message which tells the related identifier must be declared in the routine.

6 questions
10
votes
2 answers

Oracle nvl2 not working in stored procedure PLS-00201: identifier 'NVL2' must be declared

As title, I'm writing some Stored Procedure on Oracle, first I checked the version SELECT * FROM v$version; with result Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE …
RRTW
  • 3,160
  • 1
  • 35
  • 54
0
votes
1 answer

PLSQL error PLS-00201: identifier must be declared

I am working on a games users database. I am trying to create a function wich returns the number of users who live in a state (requested when executing the function). So: CREATE OR REPLACE FUNCTION userNumber(v_state users.state%type) RETURN…
PIJUS_MAGNIFICUS
  • 37
  • 5
0
votes
1 answer

PLS-00201: identifier 'COL1.POTO' must be declared

Hi I have problem with variable: Here is my code CREATE OR REPLACE Procedure WstawPotomka( wPesel IN Osoba.Pesel%TYPE, wImie IN Osoba.Imie%Type , wNazwisko IN Osoba.Nazwisko%TYPE, wDataUr IN Osoba.Data_Urodzenia%Type, wMiejsceUr IN…
Lucjan
  • 3
  • 1
0
votes
0 answers

How to get procedure to run 'PLS-00201: identifier "DISP_GUIDE_NAM' must be declared" oracle

I'm a beginner to sql and I'm having troubling calling a stored procedure. I have put down the procedure, call, and error. I have been researching for hours trying to figure out why I'm getting this error. I am a database administrator. Oracle…
LOGH
  • 1
0
votes
2 answers

Error: PLS-00201: identifier 'AST' must be declared in Package

I am getting error while running below code. I have already created a type but still getting an Error: PLS-00201: identifier 'AST' must be declared Please help me to resolve the error in ORACLE 12C. TYPE CREATION : CREATE OR REPLACE TYPE "AST" AS…
Deepak Patil
  • 17
  • 8
0
votes
1 answer

Error(66,3): PLS-00201: identifier must be declared

I have 1 procedure in with the user CC_DEVICE . In this procedure I have this statement calling a procedure of another user. of_device.p_msg.parse_csd_session(p_message); But I got this error when compiling the package: Error(66,3): PLS-00201:…
en Lopes
  • 1,863
  • 11
  • 48
  • 90