Stack Overflow
Stack Overflow

Questions tagged [ora-24338]

ORA-24338: statement handle not executed Cause: A fetch or describe was attempted before executing a statement handle.

ORA-24338: statement handle not executed

Cause:

A fetch or describe was attempted before executing a statement handle.

Action:

Execute a statement and then fetch or describe the data.

Reference:

6 questions
4
votes
2 answers

Calling oracle function using database link

I have created a oracle function called getEmployee(id in varchar) in my remote database and I'm trying to call it from my local database using database link. In getEmployee, I'm trying to return a cursor with employee data.(Table: Employee (ID,…
Kapila Witharana
  • 61
  • 1
  • 2
  • 6
4
votes
1 answer

calling a stored proc over a dblink

I am trying to call a stored procedure over a database link. The code looks something like this: declare symbol_cursor package_name.record_cursor; symbol_record package_name.record_name; begin symbol_cursor :=…
neesh
  • 5,167
  • 6
  • 29
  • 32
3
votes
1 answer

Getting a ResultSet/RefCursor over a database link

From the answers to calling a stored proc over a dblink it seems that it is not possible to call a stored procedure and get the ResultSet/RefCursor back if you are making the SP call across a remote DB link. We are also using Oracle 10g. We can…
JonathanJ
  • 171
  • 1
  • 5
2
votes
1 answer

How to execute PL/SQL Oracle in sqlplus?

I have sp in oracle. My SP is shown below create or replace PROCEDURE GETMONITORING ( v_namabarang in varchar2 default null, v_JenisLayanan in varchar2 default null, cv_1 IN OUT SYS_REFCURSOR ) AS v_where VARCHAR2(200); v_Select…
Aufal Ahdy
  • 95
  • 2
  • 10
1
vote
1 answer

Calling an oracle function from Java

I have created a oracle function called getEmployee(id in varchar) in my remote database and I'm trying to call it from my local database using database link. In getEmployee, I'm trying to return a cursor with employee data.(Table: Employee (ID,…
Kapila Witharana
  • 61
  • 1
  • 2
  • 6
0
votes
1 answer

.Net Oracle ORA-24338 'statement handle not executed' error and some error in one stored Procedure

I have the following Stored Procedures create or replace PROCEDURE WEB_AC ( v_iDocid IN NUMBER DEFAULT NULL , v_valor IN VARCHAR2 DEFAULT NULL , v_campo IN VARCHAR2 DEFAULT NULL , v_error OUT NUMBER ) AS v_campoid NUMBER(5,0); v_tipodato…
Edgar Hernandez
  • 4,020
  • 1
  • 24
  • 27