Lotus Script with Oracle

HCL Domino Domino Forum
1

Hi All,

I am getting the following error, when i execute lotus code with the Oracle Query " Error: ORA-00933: SQL command not properly ended, Conector ‘oracle’, method -Execute- (933)". Can anyone help in this…

Thanks in advance,

Kamal.

2

Subject: Lotus Script with Oracle

Maybe you have some reserved characters or words in the input.

3

Subject: Lotus Script with Oracle

Ummmmm…it obviously sounds like a poorly structured SQL call you’re making, but without seeing your code it’s well nigh impossible to know what you did wrong.

4

Subject: RE: Lotus Script with Oracle

Thanks a lot for the respose…

Please find my code :

m_sqlQuery ={SELECT pol.no_policy, agr.no_agreement, rtrim(name_first)||’ ‘||rtrim(name_middle)||’ '||rtrim(name_last), agr.no_term,

  asset.amt_asset, poltyp.desc_policy_type, pol.amt_premium, decode(pol.flag_orginalcopy_yn,'Y','Yes','N','No','--')

   FROM 		trn_policy_details pol, 

			mst_AGREEMENT agr, 

			mst_asset asset, 

			mst_customer cust, 

			MST_POLICY_TYPE poltyp

 WHERE 

			pol.no_agreement = agr.no_agreement    AND

			 pol.no_agreement = asset.no_agreement AND

			 pol.no_asset_sr = asset.no_asset_sr        AND

			 pol.no_asset_sr = 1 AND

			 agr.no_customer = cust.no_customer AND

			 pol.type_policy = poltyp.type_policy AND

			 to_date(agr.dt_disbursement,'DD/MM/YYYY') >= m_FromDateAND

			 to_date(agr.dt_disbursement,'DD/MM/YYYY') <= m_ToDate

			}

Best Regards,

Kamal.

5

Subject: RE: Lotus Script with Oracle

  1. to_date(agr.dt_disbursement,‘DD/MM/YYYY’) >= m_FromDateANDto_date(agr.dt_disbursement,‘DD/MM/YYYY’) <= m_ToDate

Are m_FromDate and m_ToDate field/variables you try to pass to SQL or are they part of existing SQL table? If it’s your variable then it should be “>= }+m_FromDate+{ AND”

You should put space character in “m_FromDateAND”

  1. rtrim(name_first)||’ ‘||rtrim(name_middle)||’ '||rtrim(name_last)

Check that “|” character does not confuse your script

  1. Run your SQL formula from external ODBC program (eg. WinSQL) and see if you get any errors there.
6

Subject: RE: Lotus Script with Oracle

Try putting a “;” at the end of the SQL query.Bye.