Jump to content

How to call oracle package in TDV


Rajarathinam J

Recommended Posts

PROCEDURE pPORT_VALIDATION_INFO(

IN IP_PSR VARCHAR,

IN IP_NPA VARCHAR,

IN IP_NXX VARCHAR,

IN IP_START_RANGE VARCHAR,

IN IP_END_RANGE VARCHAR,

IN IP_TN_RANGE VARCHAR,

IN IP_ACCT VARCHAR,

IN IP_LOCAL_PORTPS VARCHAR,

IN IP_PSR_TN_STAT VARCHAR,

 

OUT OUTPUTS PIPE( OP_TN_QRY VARCHAR,

OP_REC_CNT DECIMAL(30,0)

)

)

BEGIN

INSERT INTO OUTPUTS SELECT

OP_TN_QRY,

OP_REC_CNT

FROM

/shared/WSCommon/Physical/Metadata/MSS/PAE/ESERVICES/PK_EBONDING_PORTPS_REPORT_UTIL.PROCESS_REQUEST(IP_PSR,IP_NPA,IP_NXX,IP_START_RANGE,IP_END_RANGE,IP_TN_RANGE,IP_ACCT,IP_LOCAL_PORTPS,IP_PSR_TN_STAT);

END

 

This is the procedure i am calling oracle package in TDV from clause, but it's throwing error, could you please how to resolve this issue

Error is : Unable to parse SQL script: Incorrect syntax near "FROM", found "."

Link to comment
Share on other sites

×
×
  • Create New...