Project a SQX file added a SQL (similar to the following, omitted most of the content) :
The select A.A PP_SNO, (select COUNT (1) the FROM OTC_MATCHED B WHERE A.A PP_SNO=B.A PP_SNO AND A.A PP_DATE=B.A PP_DATE) AS MATCHED_CNT
The FROM OTC_QUOTE A;

Proc precompiled error, (script commands not to turn, the project is done with the)
Proc def_sqlcode=yes release_cursor=yes sqlcheck=syntax ireclen=256 parse=none code=CPP cpp_suffix=CPP DBMS=V8 unsafe_null=yes char_map=string % % BUILD_FILE. The SQX

(SELECT C
1> Mount (1) the FROM OTC_MATCHED B WHERE A.A PP_SNO=B.A PP_SNO AND A.A PP_DATE=B.A PP_DA
1> TE) AS MATCHED_CNT
1> .
1> .
1> .
1> .
1> .
1> .
1> ... 1
1> PCC - S - 02201, a symbol of "COUNT" in need one of the following:
1> () * + -/. @ | ats,
1> Day, hour, minute, the month, second, year,
1> Symbol "(" be replaced by" COUNT "after continue,
1> Syntax errors occur on line 3646, 569,

CodePudding user response:

Oracle 11 g client version

CodePudding user response:

Take out your statements in the run up sqlplus alone to see whether the problem of SQL

CodePudding user response:

refer to the second floor baidu_36457652 response:

alone to pull out your statements in the run up sqlplus can see whether the problem of SQL

In PLSQL run SQL sure
Don't be proc support this kind of writing? Remove the subquery, SQX can be precompiled.

CodePudding user response:

reference yinshuai215 reply: 3/f

Quote: refer to the second floor baidu_36457652 response:

Take out your statements in the run up sqlplus alone to see you the problem of SQL the

In PLSQL run SQL sure
Don't be proc support this kind of writing? Remove the subquery, SQX can be precompiled.

You write this paragraph on the inside of the procedure?
Oracle block does not support only write inside the select into to the variable

CodePudding user response:

reference 4 floor baidu_36457652 response:

Quote: reference yinshuai215 reply: 3/f

Quote: refer to the second floor baidu_36457652 response:

Take out your statements in the run up sqlplus alone to see you the problem of SQL the

In PLSQL run SQL sure
Don't be proc support this kind of writing? Remove the subquery, SQX can be precompiled.

You write this paragraph on the inside of the procedure?
Oracle block does not support only write inside the select into to the variable

Is not written in the procedure,
I am still stick source come out,,
Int CDAOOtcQuote: : Select_ESQL (ST_OTC_QUOTE_EV9 * p_pstOtcQuoteEv9, int p_iSize, int & amp; P_refiCount,
Const ST_OTC_QUOTE_EX9 & amp; P_refstOtcQuoteEx9)
{
The EXEC SQL INCLUDE SQLCA;
The EXEC SQL BEGIN DECLARE SECTION;
. Variable definitions
The EXEC SQL END DECLARE SECTION;
Int iRetCode=RTMSG_OK;
Bool bCloseCursor=false;
P_refiCount=0;
If (p_pstOtcQuoteEv9!=NULL & amp; & P_iSize & gt; 0)
{
Memset ((void *) p_pstOtcQuoteEv9, 0 x00, sizeof (ST_OTC_QUOTE_EV9) * p_iSize);
if (! CURSOR_IS_OPENED (m_uCMOtcQuoteEx9))
{
//conditions for the host variable assignment
.
//define the cursor
//{{COMPATIBILITY (DATABASE_IS_ORACLE)
The EXEC SQL DECLARE C_OTCQUOTEEX9 CURSOR FOR
SELECT *
The FROM (
SELECT ROWNUM REC_NUM APP_SNO, APP_DATE APP_TIMESTAMP, CUST_CODE, CUST_NAME, CUACCT_CODE, EXT_TA_CODE, ORG_CODE, TA_ACCT, TRANS_ACCT, EXT_ISS_CODE, INST_CODE, INST_ID, INST_SNAME, INST_TYPE, INST_CLS, HOLD_YIELD, SELL_PRICE, SELL_QTY, ORD_FRZ_QTY, SELL_MATCHED_QTY, ORD_UNFRZ_AMT, UNFRZ_AMT, RET_AMT, REDEEM_QTY, REDEEM_AMT, REDEEM_APP_SNO, REDEEM_APP_DATE, UNFRZ_QTY, CANCEL_FLAG, CANCELED_FLAG, CAN_CANCEL, CANCEL_CHNL, VALID_DATE, ORD_STAT, OP_CHNL, UNMATCH_DEAL_WAY, REMARK, MATCHED_CNT
The FROM
(
SELECT ( A.APP_SNO,A.APP_DATE,A.APP_TIMESTAMP,A.CUST_CODE,A.CUST_NAME,A.CUACCT_CODE,F.EXT_TA_CODE,A.ORG_CODE,A.TA_ACCT,A.TRANS_ACCT,E.EXT_ISS_CODE,A.INST_CODE,A.INST_ID,A.INST_SNAME,A.INST_TYPE,A.INST_CLS,A.HOLD_YIELD,A.SELL_PRICE,A.SELL_QTY,A.ORD_FRZ_QTY,A.SELL_MATCHED_QTY,A.ORD_UNFRZ_AMT,A.UNFRZ_AMT,A.RET_AMT,C.ORD_QTY AS REDEEM_QTY,C.ORD_AMT AS REDEEM_AMT,A.REDEEM_APP_SNO,A.REDEEM_APP_DATE,A.UNFRZ_QTY,A.CANCEL_FLAG,A.CANCELED_FLAG,A.CAN_CANCEL,D.OP_CHNL AS CANCEL_CHNL,A.VALID_DATE,A.ORD_STAT,A.OP_CHNL,A.UNMATCH_DEAL_WAY,A.REMARK, SELECT COUNT(*) FROM OTC_MATCHED B WHERE A.APP_SNO=B.APP_SNO AND A.APP_DATE=B.APP_DATE) AS MATCHED_CNT
A, the FROM OTC_QUOTE OTC_TRD_ORDERS C, OTC_QUOTE D, E, OTC_INST_ORG OTC_INST_ORG F
WHERE Anderson SS_CODE=E.I NST_ORG_SNO
AND A.T A_CODE=F.I NST_ORG_SNO
AND A.R EDEEM_APP_SNO=c.a. PP_SNO (+)
AND A.R EDEEM_APP_DATE=c.a. PP_DATE (+)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull