Precompilers and OCI (MOSC)

MOSC Banner

ref cursor in OCI binding error

edited Nov 1, 2010 3:56AM in Precompilers and OCI (MOSC) 2 commentsAnswered
 ver. 11.2 of db + client install

I am unable to bind the variables for a type of cursor variable. The error I get is ORA-01036: illegal variable name/number. It occurs after the OCIBindByName call

Here's the code any help would be great

[code]

//
// shows how to call a PL/SQL proc with a return of an rc
//
//
// the example uses the emp table with Scott
//
// the stored proc:
// create or replace procedure rc(rc in out sys_refcursor) is
// begin
// open rc for select empno from emp;
// end;
//
//
 
 
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <oci.h>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center