Hi
I've been able to resolve this issue, the only challenge I have is on my OUT parameter, I'm inserting INs and expect one OUT back i.e
create or replace
PROCEDURE INSERT_APPELECTRICITY
(
_QuoteType IN VARCHAR2,
p_QuoteDate IN DATE,
p_TotalCablingAmount IN FLOAT,
p_rowID OUT NUMBER
)
AS
BEGIN
INSERT INTO "AppElectricity"
(
"ApplicationID"
,"QuoteType"
,"QuoteDate"
,"TotalCablingAmount"
)
VALUES
(
APPLICATIONIDSEQ.nextval,
p_ExpectedInstallationDetail,
p_QuoteDate,
p_QuoteType
);
RETURNING "ApplicationID" into p_rowID;
END INSERT_APPELECTRICITY;
And I get this error:
Error(413,12): PLS-00103: Encountered the symbol "ApplicationID" when expecting one of the following: := . ( @ % ;