question

manmade avatar image
manmade asked

i am getting this error

SELECT
SALUSER.PRM_FN_GETPARENTOS('L',1,PMEP_PARENT_OC_CODE) ENTITY,
SALUSER.PRM_FN_GETPARENTOS('L',2,PMEP_PARENT_OC_CODE) UNIT,
(SELECT PHL_LOP_FROM FROM SALUSER.PRM_H_LOP WHERE PHL_LOP_FROM=(SELECT MAX(PHL_LOP_FROM )FROM SALUSER.PRM_H_LOP))
from SALUSER.PRM_H_LOP WHERE PMEP_EMP_ID=PHL_EMP_ID))TODATE,
from SALUSER.PRM_H_LOP ,SALUSER.PRM_M_EMPLOYEE
WHERE PMEP_EMP_ID=PHL_EMP_ID

: invalid SQL statement

oracle
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
joe_justguessing avatar image
joe_justguessing answered

looks to me like ))TODATE does not belong

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.