Home » Developer & Programmer » Precompilers, OCI & OCCI » write a pro*C program (9.0.4.0)
write a pro*C program [message #309045] Wed, 26 March 2008 05:15 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi all,
I have sql query as follows. Please write a pro*c program for the following query.
select
         sp1.cost_change
||','||  sp1.cost_change_desc
||','||  sp1.reason
||','||  to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.status
||','||  sp1.cost_change_origin
||','||  to_char(sp1.create_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.create_id
||','||  to_char(sp1.approval_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.approval_id
from     supp_prods sp1
where    sp1.cost_change   in (select sp.cost_change
                                from   supp_stat     dcp,
                                         sup_detail     spd,
                                        sup_prd         sp
                                where  sp.active_date       = to_date('02-feb-2008 00:00:00','DD-MON-YYYY HH24:MI:SS')
                                and    sp.cost_change       = spd.cost_change
                                and    spd.item              = dcp.item
                                and    spd.supplier          = dcp.supplier
                                and     sp.origin_country_id = dcp.origin_country_id
                                and    sp.unit_cost         = dcp.unit_cost)

Can any one please help me to write the pro*c code for this.

Thank you.
Kris
Re: write a pro*C program [message #309052 is a reply to message #309045] Wed, 26 March 2008 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Pro*C/C++ Programmer's Guide

How many time do you expect we will still go on trying to help you if you continue to refuse to read the documentation.

Regards
Michel

[Updated on: Wed, 26 March 2008 05:30]

Report message to a moderator

Re: write a pro*C program [message #309056 is a reply to message #309052] Wed, 26 March 2008 05:34 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Michel ,
I have tried I got .pc,.lis files but after compuloing this am not getting the other file. That's the proble.If u give me the steps.. to execute after cratting proc file then I'll folloe those steps to solve the issue.


Thank u
Re: write a pro*C program [message #309058 is a reply to message #309056] Wed, 26 March 2008 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is in the doc.

Regards
Michel
Re: write a pro*C program [message #309062 is a reply to message #309056] Wed, 26 March 2008 06:13 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you check the syntax? Because, if your code looks like your messages (see below), no wonder it won't work.
A few words from user71408's last message

compuloing, proble, u, cratting, proc, folloe
Previous Topic: Can't compile Pro*C code with 11g
Next Topic: Date+string function
Goto Forum:
  


Current Time: Fri Mar 29 02:26:48 CDT 2024