| URGENT:Couldn't figure out why this statement fails. [message #54874] |
Wed, 11 December 2002 15:20  |
Pramod
Messages: 18
Registered: April 1999
|
Junior Member |
|
|
PROCEDURE get_PAC_AttrInfo
Default Property
(
nStatus out number,
nModelID in number,
nPackageID in number,
PACAttrInfoCrusor in out PACAttrInfo_Crusor
)
IS
BEGIN
-- Open the Cursor first since we will be returning a resultset
OPEN PACAttrInfoCrusor FOR
-- Our SQL Statement that will select the data into the cursor
SELECT A1.Name, 'S' InputType, A1.GroupNumber, A1.AttributeID,
(SELECT APD.Name
FROM Attributes A2
INNER JOIN AttributeProperties AP
ON A2.AttributeID = AP.AttributeID
INNER JOIN ModelInt_Selections MIS
ON AP.AttributePropertyID = MIS.AttributePropertiesID
INNER JOIN AttrPropertyDictionary APD
ON AP.AttrPropertyDictionaryID = APD.AttrPropertyDictionaryID
WHERE A2.AttributeID = A1.AttributeID) DefaultProperty
FROM Attributes A1
WHERE ModelID = nModelID;
-- Set return status = 0 (Success)
nStatus := 0;
EXCEPTION
-- This is where we will jump if any type of error happens
WHEN OTHERS THEN
-- Set return status (Failure)
nStatus := ERR_GET_FAILURE;
-- This will force an error to raise up to the client application
RAISE_APPLICATION_ERROR(ERR_GET_FAILURE, SQLERRM);
END get_PAC_AttrInfo;
##################
Error I get
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
THANX in advance.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
