ORA-06561: given statement is not supported by package DBMS_SQL
Cause: Attempting to parse an unsupported statement using procedure PARSE provided by package DBMS_SQL.
Action: Only statements which begin with SELECT, DELETE, INSERT, UPDATE, LOCK, BEGIN, DECLARE or lamp;lt;lamp;nbsp;lamp;lt;lamp;nbsp; (PL or SQL label delimiter) are supported.
Cause: Attempting to parse an unsupported statement using procedure PARSE provided by package DBMS_SQL.
Action: Only statements which begin with SELECT, DELETE, INSERT, UPDATE, LOCK, BEGIN, DECLARE or lamp;lt;lamp;nbsp;lamp;lt;lamp;nbsp; (PL or SQL label delimiter) are supported.
where is my error:
ReplyDeleteSELECT DA.CREATED_DATE,
DA.CARGO_TAG1,
CID.PAINT,
SCVD.MODELDESCRIPTION,
SP.PORT_NAME,
DRIVERNAME,
DD.COMPANYCODE,
DA.LOCATION,
STACK_LEVEL
FROM SUP_DRIVER_DETAILS DD,
DRIVER_ACCESS DA,
ITEMS I,
CLIENT_ITEM_DETAILS CID,
SUP_PORTS SP,
SUP_CLIENT_VEHICLE_DETAILS SCVD
WHERE DA.DRIVER_PERMIT = DD.PERMITNUMBER
AND DD.DEACTIVATEDDATE IS NULL
AND DA.TERMINAL_CODE = :APP_TERMINAL_CODE
AND DA.CARGO_TAG1 = I.CARGO_TAG1
AND I.TERMINAL_CODE = DA.TERMINAL_CODE
AND CID.ITEM_NO = I.ITEM_NO
AND CID.TERMINAL_CODE = I.TERMINAL_CODE
AND I.CANCELLED_DATE IS NULL
AND SP.PORT_CODE = I.DESTINATION_PORT
AND SP.ACTIVE_FLAG = 'Y'
AND SCVD.MODELCODE(+) = CID.MODELCODE
AND DA.CREATED_DATE BETWEEN :P_START_DATE AND :P_END_DATE
ORDER BY DA.CREATED_DATE;