am I using this for loop correctly


Posted on 16th Feb 2014 07:03 pm by admin

Dear buddies!

Right now I am generating a report with some details for all the dealers.

Did you know?Explore Trending and Topic pages for more stories like this.
I am required to separate the report for each dealer respectively in separate reports. I tried this method and its not of help.

Please advice.

procedure convert_excel IS dealer_name varchar2(100); begin -- Test statements here for dealer_name in (select dealer_long_name from tbl_dealers) loop print_report( 'select dealer_region as "Dealer Region", dealer_long_name as "Dealer Name", "# of Received" as "#of Customer Received", "#of Converted", "%of Conversion" , from dealer_performance t where dealer_name = t.dealer_long_name', 'dealer_performance||dealer_name||.xml','Y'); end loop;

I didn't receive any compilation error. Compilation is successful.

I received an error when I was executing.

ORA-00904: "DEALER_NAME": invalid identifier

Please advice, where I am making the mistake.

Thanks.
No comments posted yet

Your Answer:

Login to answer
181 Like 42 Dislike
Previous forums Next forums
Other forums

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

newbie question about multiple queries
hi everyone,
I'm sorry to ask such a basic question, but I'm young and trying to learn php on my

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

Mass activity scheduling
Hi experts,

Im facing some problems to deal with mass activity jobs.
When I run some

sendmail code suddenly not working
Hi Guys, I maintain 3 sites (including my own) I use the following code from a french webmaster that

Output Buffering question
Hi all,

I've been trying to wrap my head around output buffering. So far I've found tons of

ALV sum various columns problem
Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is s

Match stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash