| |
664 Search Results Found |
| 1 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sun, 19 March 2023 08:17 «»
By: peternac26
PRO*C Windows Visual Studio 2022
…all,
I am trying to set up a lap to run pro*C in windows with Visual Studio 2022 in Oracle 21c.
I have this guide //docs.oracle.com/database/121/LNPCC/pc_ahintegrat.htm#LNPCC5137 which I see outdated and a poor copy paste of the first version for …
|
| 2 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 06 April 2021 13:53 «»
By: Ylei
Pro C compile error
…
Hi ,
I received the following error after I downloaded a new copies of /opt/oracle/products/dbclient from website and trying to recompile the Pro C code:
/opt/oracle/products/dbclient/sdk/proc: Symbol `kpccapCTarr' has different size in …
|
| 3 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Wed, 20 January 2021 03:29 «»
By: brown_zzz
Pro C program fails with
…have a pro*c process continually running that every 5 minutes reads from a materialised view 132,000 rows, does some processing and writes to another table. Approximately once a day (at different times) this is crashing with "ora-3114 not connected …
|
| 4 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Fri, 04 September 2020 10:13 «»
By: zephyrin
Pro*C and 2 databases
…Hi,
I write a program that needs to access at 2 databases in the same file toto.pc.
How do the pre-compiler know the 2 connections ?
Until now, I need 1 connection and I write in the makefile :
PROC = proc THREADS=YES
PROCPPFLAGS = define=…
|
| 5 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 23 January 2020 03:49 «»
By: NevemTeve
In Pro*C, can UPDATE return sqlca.sqlcode=1403 ?
… a bad question; I know it can, as I just got sqlca.sqlcode=1403 when zero line matched the WHERE condition of an UPDATE.
With Sql*Plus I get the expected result: "0 rows updated"
So my only question: is this behavior of Pro*C documented…
|
| 6 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Mon, 29 April 2019 09:44 «»
By: mnardi
Oracle Database 18c XE and Pro*C
…Hi,
could we use Pro*C with Oracle Database 18c XE ?
more precisely, I want to compile Pro*C on an AIX server and use Oracle Database 18c XE on a Linux server. Is it possible ?
if not, can I do this compilation if everything is on a linux …
|
| 7 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Mon, 09 July 2018 10:15 «»
By: panduro
Is Pro*C supported in Linux?
…experts,
I got a customer question: Is Pro*C supported in Linux?
They are currently using Pro*C on Solaris on SPARC and are planning to move to Linux in x86 but would like to know first if their Pro*C code will work fine in Linux as it does now in …
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 29 May 2018 15:14 «»
By: gunderj
cannot use UTL_SMTP on Windows 10 pro from machine at home
…are the experts doing about Windows 10 pro lack of SMTP server? I want to use UTL_SMTP but it requires an SMTP Server which is not readily available in Windows 10 pro (my home machine). I've done this successfully at work but work already has SMTP …
|
| 9 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 04 July 2017 10:15 «»
By: gauri2512
COBOL and ORACLE (Pro* COBOL)
…our application is built in Pro*COBOL which was working fine in 11g but as we are upgrading on 12c its is giving error invalid USERNAME/PASSWORD
where as we are able to connect through normal command prompt.
but there is no mention of any changes …
|
| 10 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sun, 22 January 2017 23:56 «»
By: dvsuresh2010
unable to generate pro*c .exe file on solaris11
…Mentor,
Unable to generate pro*c .exe file on Solaris11. I am getting the below error. Please help.
oracle@dcn2ddbx005:/var/opt/dev/atlas10g/hpwunx/proc$ make -f c_probe.mk build EXE=check_postcode OBJS=check_postcode.o
proc sqlcheck=semantics …
|
| 11 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 21 July 2016 22:52 «»
By: hui shen
Pro*COBOL Dynamic SQL How to get data length of a VARCHAR2 column
…experts
I am using procob dynamic sql to execute a sql query statement, but i could not find a way to get real data length value of a VARCHAR2 column.
For example:
CREATE TABLE TESTAB(CCC VARCHAR2(10));
INSERT INTO TESTAAB VALUES('1234');
…
|
| 12 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Wed, 02 March 2016 23:20 «»
By: sumanbangladesh
Error in Pro*C file compile
… running Oracle 11g on AIX 7.1 and I compile Pro*C file like below:
$ make -f abc.mk clean
$ make -f abc.mk build
Previously it was working fine but recently I am facing problem at second build statement as follows:
SEVERE ERROR: Archive file ./…
|
| 13 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sun, 29 March 2015 10:27 «»
By: Asfakul
Setting up Pro*C Pre compiler in Windows
…to Setting up environment for working with Pro*C. I want to use Pro* C with Oracle database to develop applications. I will not be able to understand obscure references and jargon related to Pro*C. If possible please give distinct steps I need to follow…
|
| 14 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Wed, 11 February 2015 11:07 «»
By: raghx
Pro*C migration from Solaris to RHEL
…orm.
I assume that we point the makefile to Pro*C libraries on RHEL and recompile?
However I need some advise and help, as what would be the impact of such OS migration on the Pro*C code? Do we have to re-write or a simple recompile will be …
|
| 15 |
Forum: Other Operating Systems «»
Posted on: Mon, 09 June 2014 10:38 «»
By: apru
Pro * Cobol
…from z/os.I read about an option called Pro*Cobol but did not get proper details regarding the product like if it is open source or not,what is the process for installation in z/os,JCLs required etc.I even doubt if it available for z/os.Can some one …
|
| 16 |
Forum: Windows «»
Posted on: Fri, 11 April 2014 17:28 «»
By: txblackbird
Installing 11gR2 on Windows 7 Pro 64-bit dies...
…All.
I am attempting to install 11gR2 onto a Windows 7 Pro 64-bit system. I have 18 GB of Ram and multiple hundreds of GB of free disk space on my hard drives.
I have tried multiple times using different configuration options to successfully …
|
| 17 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Fri, 26 July 2013 03:07 «»
By: paranada_g
Pro*C++ Resultset Data types question
…Hi,
I want to migrate an application in pro*c as all the mass code of pro*c will be simplify as much as possible. To do so, i neet to access de data base data throw a resultset, so i don,t neet to know which data(And type, "int, string, etc"…
|
| 18 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Fri, 25 January 2013 07:51 «»
By: maro
Pro*C file compilation error
…Hi,
I got an error while compiling p08-3 pro*c file in Linux. How to solve this error?.
bash-3.2$ pc -f p08-3 bht-cims.o cims-soc.o
Libsource set to /procims/libsource
Pre-Compiling p08-3.pc
Compiling p08-3.c
Linking p08-3.o bht-cims.o cims-soc…
|
| 19 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Wed, 05 December 2012 06:01 «»
By: akshayarwind
Pro C files not converting from .pc to .c
…have a number of .pc (Pro C)files that I need to compile in Linux.When I am trying to build it using make
it gives the following error
Syntax error at line 32, column 33, file /home/corelogic/sunstudio12.1/prod/include/CC/stlport4/cstdio:
Error at …
|
| 20 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Mon, 26 November 2012 23:14 «»
By: rosomaha101
calling procedure from PRO C
Hi
I am trying to call procedure from PRO C
Procedure has many parameters and I do not need to put all of them when I call procedure.
Is there way to make the same way as in PL/SQL
like this
my_procedure( q=>a1 , b=>'abc )
Thanks
|
| 21 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Mon, 03 September 2012 04:27 «»
By: gajanansp
Call Stored procedure with input variable as object type in pro *c
…calling stored procedure i am getting following error
PLS-S-00306, wrong number or types of arguments in call to PR_PROCESS_BASKET
specifications of package are as follow
PROCEDURE PR_PROCESS_BASKET(PI1 IN NUMBER…
|
| 22 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 19 June 2012 09:23 «»
By: harris_a
Pro*C using OCI (21700: object does not exist or is marked for delete)
…and be able to call and return this to a Pro*C program (mainly for the simplicity of file output, rather than using UTL_FILE to write directly from a package).
The Details
The process:
- 1 user defined object type, has 2 varchars and a number
- …
|
| 23 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 12 June 2012 12:55 «»
By: raghx
Pro*C XML sample
Hi All,
I'm require to read a JMS/XML message from Websphere MQ using Pro*C. Hence would like to have any sample program to read XML data using Pro*C. With XSD should be fine.
Please help.
|
| 24 |
Forum: Marketplace «»
Posted on: Tue, 08 May 2012 06:15 «»
By: supertime2000
Pl/Sql, Pro*C Process Code Generator For Oracle
Create Multi Table Source Code in Minutes, without Programming
|
| 25 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 17 April 2012 09:46 «»
By: Bruble
precompiler pro*COBOL ends with fatal error no prev errors
….cs9 files are not being produced by the pro*compiler and have removed all comments, pagination, EXEC SQL ... END-EXEC references and the need for copy books to be brought in. The code is now pure cobol. A fatal error occurs within the pro*COBOL compiler …
|
| 26 |
Forum: Linux «»
Posted on: Mon, 13 February 2012 01:26 «»
By: jjose122
How to executea pro c script from Linux
…,
I had a pro c script which was successfully running in Solaris server.
nnow i want the same script to run from LInux machine. When i run the script.. I am getting the below error
cannot execute [Exec format error]
Could you please let me …
|
| 27 |
Forum: Marketplace «»
Posted on: Thu, 12 January 2012 08:06 «»
By: smartgupta
Career in Pro*C
…Experts,
My company wants me to work on pro*c. I have no idea about pro*c. So I want to know If I will go for it, what is scope and career growth in future?
Will it be right choice to work on pro*C?
Please guide me and provide me your valuable …
|
| 28 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Tue, 13 December 2011 09:17 «»
By: 12sudhanshu
oracle Pro C (2 Merged)
…all,
I am new in oracle pro c. i have installed oracle 10g on mt laptop(windows xp 32 bit). i want to run pro c on that.What step should i fallow to run the proc. how i get to know that pro c is installed on system. if not installed then how i should …
|
| 29 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sat, 22 October 2011 21:52 «»
By: 9390512774
pro*c Error "Invalid initialization"
…Experts,
I wrote a pro*c program. i am providing you a sample program which a similar one to my prog. but its not a exact test case.
#include<stdio.h>
#include<stdlib.h>
#include<string.h>
EXEC SQL BEGIN DECLARE SECTION…
|
| 30 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sat, 17 September 2011 01:01 «»
By: 9390512774
Pro*c Error
…All,
I installed oracle 10.2.0.1.0 in OEL5.0.
when i am entering the keyword "proc" on command line it shows the following error messages
proc: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No …
|
| 31 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 15 September 2011 10:39 «»
By: 9390512774
Pro*C installation
…All,
I want to practice PRO*C on my Personal PC.i installed OEL5.0 on my PC.BY fallowing the below link.
http://oracle-base.com/articles/linux/OracleEnterpriseLinux5Installation.php
Can any one help me on installing Pro*C on my personal PC.
what…
|
| 32 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Wed, 22 June 2011 09:37 «»
By: hugh12
Help with pro SQL dump and Oracle Apex sql commands
…I am a student and encountering issues in a task I am attempting. I have a pro SQL database dump which I want to import into Oracle apex to create a database app but I havnt found any method for doing this so I decided to manual create the tables in the …
|
| 33 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Fri, 15 April 2011 10:31 «»
By: Emma1970
Multithreading/Pro*C Insert Issue
…threads=yes to proc precompiler and using Pro*C/C++: Release 11.2.0.1.0.
Even if the EXEC SQL CONNECT is put in the the threaded function the same thing seems to happen so i moved it out to its own function to see if it would work but it made no …
|
| 34 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Mon, 28 February 2011 10:37 «»
By: Agitatra
Pro*C - how to compile with SQLCHECK when access to meta-information requires a SET ROLE
… (no chance of altering any parameters) with Pro*C/C++ using both: "EXEC SQL SELECT" and: "EXEC SQL EXECUTE" statement. Therefore Pro*C requires the activation of at least: "SQLCHECK=semantics". However, to access the …
|
| 35 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Fri, 28 January 2011 15:52 «»
By: idiazr
Cobol calling PRO*C
…var1 var2 var3 var4 ....... var21
givinh var22 var23 ....
Are something wrong in C programm ??????
Pro*C code from vouters.dyndns.org/tima/OpenVMS-Cobol-C-Cobol_passing_variable_number_of_arguments_to_C.html
Modify by me…
|
| 36 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 20 January 2011 10:05 «»
By: 9390512774
help pro*c variable declarations
…type of host varible i have to declare in Pro*c.
that is supporting plsql table type returning 3 columns and unknow no of rows (0 to any no of rows).
example the follwing data is in out mode varaible in plsql function.
.................
abc…
|
| 37 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 20 January 2011 08:57 «»
By: sacan
pb pro*c demo_proc.mk
In fedora core 13 with Oracle Middleware fusion 11gR2
my pcscfg.cfg:
my command:
make -f demo_proc.mk --debug
and the result:
thank for your help
|
| 38 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Fri, 07 January 2011 15:12 «»
By: idiazr
Pro*Cobol get ORA-01458: invalid length inside variable character string
…a programm Pro*Cobol I have this varaiable
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
03 code pic 9(06).
03 amont pic 9(12).
03 resp Pic X(10) VARYING.
EXEC SQL END DECLARE SECTION END-EXEC.
Then
EXEC SQL EXECUTE
BEGIN
PKG_PUNTOS.calculate…
|
| 39 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Sun, 12 December 2010 06:40 «»
By: supreeth080
PRO C
…All,
I have a problem in calling a procedure from a PRO C file.
The structure of the procedure is:
CREATE OR REPLACE PROCEDURE abcd(a IN NUMBER, b IN DATE, c OUT FLOAT, D OUT sample_type) IS
BEGIN
.........
--PROCEDURE …
|
| 40 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 18 November 2010 08:00 «»
By: vikrant_jain
passing variable of size greater than 32767 from Pro*C to PL/SQL procedure
…a variable os size greater than 32767 from Pro*C to an SQL procedure.I tried assigning the host variable directly to a CLOB in the SQL section but nothing happens.In the below code the size of l_var1 is 33000.PROC_DATA is a procedure that takes CLOB as …
|
Blog
Search
Help
Members
Register
Login
Home