Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

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 an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...