Hi all,
I'm quite new in writing PL/SQL.. Can anyone help me with following error:
PL/SQL:
CREATE TABLE saptest
(
id NUMBER(10,0)
);
/
CREATE OR REPLACE FUNCTION p_MONSCLGReturnColumns_ins
(
v_Database_Name IN NVARCHAR2 DEFAULT NULL ,
v_Procedure_Name IN NVARCHAR2 DEFAULT NULL ,
v_Column_Name IN NVARCHAR2 DEFAULT NULL ,
v_Data_Type IN NVARCHAR2 DEFAULT NULL ,
v_Max_Length IN NUMBER DEFAULT NULL ,
v_Ordinal_Position IN NUMBER DEFAULT NULL ,
v_DateProcColumnGenerated IN DATE DEFAULT NULL
)
RETURN NUMBER
AS
BEGIN
BEGIN
BEGIN
BEGIN
INSERT
INTO MONSCLGReturnColumns
(
Database_Name,
PROCEDURE_NAME,
Column_Name,
Data_Type,
Max_Length,
Ordinal_Position,
DateProcColumnGenerated
)
VALUES
(
v_Database_Name,
v_Procedure_Name,
v_Column_Name,
v_Data_Type,
v_Max_Length,
v_Ordinal_Position,
v_DateProcColumnGenerated
);
END;
EXCEPTION
WHEN OTHERS THEN
END;
RETURN 0;
END;
EXECUTE IMMEDIATE ' CREATE UNIQUE INDEX idx1 ON saptest ( id)';
END;
Error:
Error(41,5): PLS-00103: Encountered the symbol "END" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge
Thanks.
rgds,
shahrir