Liquibase migration with oracle pl/sql function gets PLS-00103

Community Answers
3

Hi @NathanVoxland

Thanks for revert, I could able to resolve issue by adding “/” at the end of SQL statements.
Issues was with only oracle package create and update statements, where package was getting updated however “;” was missing and not able to compile
-----------------------------------------
Database Change log file: **
-----------------------------------------

** <sqlFile dbms="oracle"
** endDelimiter=";"**
** path="./V28_PKG_TEST.sql"**
** relativeToChangelogFile=“true”**
** splitStatements=“false”**
** stripComments=“false”/>**

----------------------------------------------------------------------------------------------------------------------------
SQL Script : V28_PKG_TEST.sql
----------------------------------------------------------------------------------------------------------------------------

create or replace procedure PKG_TEST
(
pTTHID NUMBER,
pTHRESHOLD NUMBER,
pMINCOUNT NUMBER,
pTTHFalg VARCHAR2,
pOutCursor OUT SYS_REFCURSOR
)
IS
/----------------------------------------------------------------------------------------------------------------------------
Project : PROJECT
Short Description : This sp is used for displaying data on Threshold Page
Developer Name :
Created Date :
----------------------------------------------------------------------------------------------------------------------------/

BEGIN

BEGIN
if (pTTHID = ‘1’ AND pTHRESHOLD = ‘1’) THEN
OPEN pOutCursor FOR
SELECT BUSSINESS_ID, BUSSINESS, THRESHOLD FROM FINS_TransTrendsHourlyThreshold Order by 1 ASC;
ELSE
IF (pTTHFalg = ‘UPDATE’) THEN
UPDATE FINS_TransTrendsHourlyThreshold SET THRESHOLD = pTHRESHOLD WHERE BUSSINESS_ID = pTTHID;

      OPEN pOutCursor FOR
      SELECT BUSSINESS_ID, BUSSINESS, THRESHOLD FROM FINS_TransTrendsHourlyThreshold Order by 1 ASC;
    ELSE
      OPEN pOutCursor FOR 
      SELECT BUSSINESS_ID, BUSSINESS, THRESHOLD FROM FINS_TransTrendsHourlyThreshold WHERE BUSSINESS_ID = pTTHID;
    END IF;
  END IF;

END;
EXCEPTION
WHEN OTHERS THEN
pOutCursor := NULL;

END;
/