> My script has a statement handle that accepts only one parameter. I am
> assigning the parameter given to the $ARGV[0]. I run the script from the
> command line, also sending the parameter. I am also assigning all selected
> values to an array for output.
> I continue to get this message:
> Can't execute file handle: ORA-01008: not all variables bound (DBD:
> oexfet error)
>
> Here is most of the statement:
> $fetch_GLD_BILL_details= $dbh->prepare("select distinct
> substr(ne.general_18,82,1) CLASS,
> substr(ne.general_18,83,1) MSG_TYPE,
> c.charge AMOUNT,
> ne.c_party_id MAIN_BILL_NUM,
> SUBSTR(ne.a_party_id,1,3) CALLING_NPA,
> SUBSTR(ne.a_party_id, 4,3) CALLING_NXX,
> SUBSTR(ne.a_party_id,7,10) CALLING_LINE,
> rc2.abbreviation FROM_CITY_STATE,
> DECODE(SUBSTR(ne.a_party_id,1,3),SUBSTR(ne.b_party_id, 1,3), 'A', 'R')
> Inter_Intra,
> DECODE(NE.EVENT_SUB_TYPE_CODE,110, NE.C_PARTY_ID,'0000000000') AUTH_CODE,
>
> DECODE(ne.event_sub_type_code,110, ne.general_14, '0000') PIN,
> NVL(cnda.index1_value, '000000000000') PAC_Code,
> substr(ne.general_18,4,2) category,
> SUBSTR(TO_CHAR(I.ISSUE_DATE,'DD-MON-RRRR'),8,11) Stmt_YEAR,
> TO_CHAR(I.ISSUE_DATE,'MM'),
> SUBSTR(TO_CHAR(I.ISSUE_DATE,'DD-MON-RR'),1,2) Stmt_DAY
> FROM customer_node_history cnh,
> customer_node_da_array cnda,
> product_instance_history pih,
> product_history ph,
> service_history sh,
> service_type st,
> charge c,
> invoice i,
> and SYSDATE between cnh.effective_start_date and cnh.effective_end_date
> and SYSDATE BETWEEN pih.effective_start_Date and pih.effective_end_Date
> and SYSDATE BETWEEN ph.effective_start_Date and ph.effective_end_Date
> and SYSDATE BETWEEN sh.effective_start_Date and sh.effective_end_Date
> and cnh.node_name_uppercase = ?");
>
> $customer_name = $ARGV[0];
>
> Please advise,
>
> Kim Green
> Billing Systems Developer
> Madison River Communications
> 919.563.8385
> [EMAIL PROTECTED]
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
