Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared.
PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared. [message #212373] Fri, 05 January 2007 00:31 Go to next message
darshso
Messages: 2
Registered: January 2007
Junior Member
Hi,
Please let me know how to resolve this error PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared.

Thanks in advance.

CREATE OR REPLACE PACKAGE BODY STSD_PROJECT_CREATION AS

FUNCTION STSD_PROJECT_CREATE
(P_TEMPLATE_ID IN NUMBER,
P_PROJECT_NAME IN VARCHAR2) return VARCHAR2 IS

PROJECT_FROM_TEMPLATE
(P_TEMPLATE_ID => P_TEMPLATE_ID,
P_PROJECT_NAME => P_PROJECT_NAME,
P_MANAGER_ID => P_MANAGER_ID,
P_USER_ID => P_USER_ID,
P_USR_DBG => P_USR_DBG,
O_NEW_PROJECT_ID => l_new_project_id,
O_LAST_UPDATE_DATE => l_last_update_date,
O_ENTITY_LAST_UPDATE_DATE => l_entity_last_update_date,
O_MESSAGE_TYPE => l_message_type,
O_MESSAGE_NAME => l_message_name,
O_MESSAGE => l_message);

[Updated on: Fri, 05 January 2007 02:20]

Report message to a moderator

Re: PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared. [message #212387 is a reply to message #212373] Fri, 05 January 2007 01:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
read up on syntax of stored program units.
At first glance I spot two errors:
1) what type of unit is project_from_template?
2) you missed an "end" keyword denoting the end of the package
3) (bonus!) You missed a semicolon after the definition of the first function
Re: PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared. [message #212395 is a reply to message #212387] Fri, 05 January 2007 02:23 Go to previous messageGo to next message
darshso
Messages: 2
Registered: January 2007
Junior Member
I have pasted only a part of the PL/SQL package showing the main area where the error is found.
Re: PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared. [message #212400 is a reply to message #212395] Fri, 05 January 2007 03:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ok, so that lets you off error 2).

At the very least, you are missing a BEGIN before the line that says 'PROJECT_FROM_TEMPLATE'.
Re: PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared. [message #212468 is a reply to message #212400] Fri, 05 January 2007 08:11 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Hm, second glance: I missed the fact that this is a package body. I don't know if you updated that or that I completely misread your code.
Sorry for that.
Previous Topic: define row size of a table
Next Topic: keyboard input related
Goto Forum:
  


Current Time: Fri Dec 09 23:19:33 CST 2016

Total time taken to generate the page: 0.08455 seconds