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.

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.

Your Answer:

Login to answer

Other forums

textfield unchanged
hi,
i want my form to know whether its textbox is unchange or not.

if($textbox == 'unchang

Auto fill in input value based on User_ID
Hello,

I'm looking form some input on the following problem.

User loads page ->

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

php mailer
How can i send a mail to large no, say 50,000 reciepients using [color=#0000FF]php mailer[/color]

array_combine() error
getting an "Warning: array_combine() [function.array-combine]: Both parameters should have an e

Warning: mysql_num_rows() expects parameter 1
When i add quote at the end of this link
example:http://localhost/articlemania/category.php?cid=3

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on