oracle « Development « C File Q&A

1. How to compile pro*c file on visual studio 2010    stackoverflow.com

I installed visual studio 2010 recently. And my project migrate from visual studio 2005 to 2010. After migration, I can't compile pro*c file in my project on visual studio 2010 (after ...

2. Utl_file fseek function giving error with large absolute offset?    stackoverflow.com

I have to make a program that will use fseek to read data from pirticular position. i have to read data line by line,and in pirticular line i have to use fseek ...

3. How can i find the oracle package name in the pro*c file?    stackoverflow.com

Consider the package name as "ORA_DATAUPDATE" which is in oracle database. There are a lot of Pro*c files (more than 100 files ) in the UNIX environment. Maybe one or ...

4. Log file avoid dumping sql query data in it.. c shell    stackoverflow.com

I have sql script "example.sql":

SPOOL &1
Select '<.TR>'||'<.TD align="left">'||column_name||'<./TD>'||'<.TR>' from table1;
spool off

sqlplus $ORA_UID/$ORA_PSWD ...

5. Pro*C generating garbage files    dbasupport.com

I recently installed 10gR2 on SuSE Linux 10.0. My application uses Pro*C, but after re-installation, the proc command always generates three randomly named files beginning with tp. For example, here's one of my compiler steps: chris@dev[152]:~/src/dcsrv/DcsDB% ll tp* ls: No match. proc sqlcheck=full cpp_suffix=cxx code=cpp userid=magic/wizard char_map=string include=.. include=VC SharkQuoteTbl.pc oname=SharkQuoteTbl.cxx > SharkQuoteTbl.pc.L chris@dev[154]:~/src/dcsrv/DcsDB% ll tp* -rw------- 1 chris users 0 ...

6. Check file on c:\drive    dbasupport.com

Hi everybody, What exactly I am trying is I am invoking sqlldr through d2k form using HOST(); in addition I have to invoke *.bad or *dsc file in case data file is incorrect. In this case I want to check first which file has been created/not created on c:\.... depends, so before I invoke notepad to see the *dsc or *bad ...

7. make file in pro*c    dbasupport.com

hi, since im new to pro*c and the make file stuff. im unable to run $make -k or $make -f demo_proc.mk ansidyn1 if i run the command in #make -k or make -f demo_proc.mk ansidyn1 im getting cc: /lib/libsql.a: No such file or directory ... .... could any one help me?? thanks, peri sekar

8. Fetching Data Value from unix script to Pro* C file to insert the value in Oracle DB table    orafaq.com

All, I need an urgent help for reporting purpose. I have Batch process written in Pro* C language from where i am executing various objects which is generating Output forms. Then i am calling an "FT.sh" from the Pro*c file which is creating a consolidated TAR file for all the generated output forms. Once the Taring activity is completed i need ...

9. how to compile .pc file in pro c    orafaq.com

Hi, I have a proc c project which is already built. I am just changing text on one of the file which has ".C" extension. And i also need to change text on ".PC" file but problem is when i double click to open .sln which is my project file and i dont find ".PC" extension file on my visual studio. ...

10. undefined reference error while compiling C file using BerkeleyDB api    dbforums.com

11. Using Cursor Attributes in Pro*C program(.pc file)    dbforums.com

hi, Does anyone know, what is hte equivalent of following PLSQL code in PRO*C?? declare cursor c1 as select * from emp; begin if c1%isopen then close c1; else open c1; end; / I m able to get the cursor working succefully as such. But before my procedure opens it, i want to check whether it has been left open by ...

12. Callinf "C" DLL Files from PL/SQL    dbforums.com

13. ORA-01991: invalid password file 'C:\oracle8i\ora81\DATABASE\PWDrichard.ORA'    dbforums.com

Hi, I am learning Oracle part two of the OCP exam and I am trying to create a step by step database via SQL*Plus. I know I can use OEM or other means to create it, but I want to know each steps. All the right parameters have been set in the init.ora file. I enter the command create database nancy, ...