Re: [sqr-users] troubleshoot dynamic SQL

["Larry Roux" <LRoux@syr.edu>]

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