OraFAQ Forum: Precompilers, OCI & OCCI » PLS-S-00201, identifier 'TABLE' must be declared

Home » Developer & Programmer » Precompilers, OCI & OCCI » PLS-S-00201, identifier 'TABLE' must be declared (Oracle 10g in HP-UX B.11.11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PLS-S-00201, identifier 'TABLE' must be declared [message #322015]

Thu, 22 May 2008 02:51

donato
Messages: 53
Registered: November 2007
Location: Barcelona, Spain

Member

Hello,

I'm trying to compile the example program of the Oracle's documentation.

I'm using this precompiler options:

MODE=ANSI
CLOSE_ON_COMMIT=NO
DYNAMIC=ANSI
CODE=ANSI_C

Therefore, i add to the program source this clauses (in the correct place):

EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;

Well, i'm think all is fine. But i obtain this error:

PLS-S-00201, identifier 'EMP' must be declared

If a try to compile a simplest program, like that:

#include <stdio.h>
#include <myLibrary.h>
short main(int argc, char **argv)
{
	EXEC SQL BEGIN DECLARE SECTION;
		int status;
	EXEC SQL END DECLARE SECTION;
	
	/* This is an extern function that connects to oracle */
	dbconnect();	

	
	EXEC SQL 
	SELECT 1
	INTO :status
	FROM DUAL;
	
	/* This is an extern function that makes a rollback to oracle */
	dbrollback();
}

I'll obtain the same error, in this case with 'DUAL'.

Can you help me, please?

Report message to a moderator