Re: [sqr-users] troubleshoot dynamic SQL

["Ben Anderson" <pegandersonbd1@hotmail.com>]

I realized the problem.  We use a separate procedure for handling errors in 
production.

Begin-Select on-error=ora_err

This suppresses SQR's detailed error message.  I removed the 
on-error=ora_err for testing and I can now see the detailed error message.

-Ben


>From: "Larry Roux" <LRoux@syr.edu>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] troubleshoot dynamic SQL
>Date: Tue, 25 Mar 2003 09:18:07 -0500
>
>I have only run an SQR with the -S flag while we were still a Sybase shop.  
>I never received results like you show below.  I always got the actual 
>statement.
>
>The error should show the line number of the start of the SQL statement in 
>the SQR.  Can you send that code?
>
>
>
>
>******************************
>Larry Roux
>Syracuse University
>lroux@syr.edu
>*******************************
>
> >>> pegandersonbd1@hotmail.com 03/25/03 08:58AM >>>
>I was not familiar with the -S option so I just tried it out.  I'm testing 
>a
>report right now that consists of a dynamic sql statement.  What I'm
>wondering is if there is a way to print out the actual SQL statement 
>instead
>of the variable names.  Here is my output.
>
>Cursor #4:
>    SQL = SELECT [$select_bd_trans_date], [$select_cli_cost_center],
>          [$select_cli_pr_client_nbr], [$select_ph_clt_id],
>          [$select_cli_client_name], [$select_ph_policy_nbr],
>          [$select_ph_policy_id], [$select_btt_adj_type],
>          [$select_bd_amount], [$select_btg_dr_cr]
>    From [$cltinfo.client]
>          [$wc.bank_detail] [$wc.bank_trans_type] [$wc.bank_trans_group]
>          [$ins.policy_history] Where
>          [$link_cltinfo.client_TO_wc.bank_detail] and
>          [$link_wc.bank_detail_TO_wc.bank_trans_type] and
>          [$link_wc.bank_trans_group_TO_wc.bank_trans_type] and
>          [$link_ins.policy_history_TO_wc.bank_detail] and
>          [$query1_ON_ph_clt_id] and [$query1_ON_ph_policy_id] Order by
>          [$group1] [$order_by2]
>Compiles = 0
>Executes = 0
>Rows     = 0
>
>
>
> >From: "George Jansen" <GJANSEN@aflcio.org>
> >Reply-To: sqr-users@sqrug.org
> >To: <sqr-users@sqrug.org>
> >Subject: Re: [sqr-users] ORA-00937: not a single-group group function
> >Date: Tue, 25 Mar 2003 08:26:39 -0500
> >
> >Might I point out that the error you got is ORA-00936, "missing
> >expression", not 937, the single-group etc.?
> >
> >What if you were to run this with the "-S" flag to see what cursor
> >exactly is bombing?
> >
> >
> >
> >_______________________________________________
> >sqr-users mailing list
> >sqr-users@sqrug.org
> >http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>_________________________________________________________________
>Protect your PC - get McAfee.com VirusScan Online
>http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users