python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - oracle19c

alternative tables all_types for package define types in oracle db

I use oracle 19. The following type is declared in the package. CREATE OR REPLACE package MYUSER.mytest is TYPE MY_TABLE IS TABLE OF VARCHAR2(30); FUNCTION mytable_test ( in_param IN ...
test-img

Andrey Vladimirovich

sql

database

oracle

oracle19c

Votes: 0

Answers: 1

Latest Answer

Look in all_plsql_types instead: SELECT * FROM all_plsql_types WHERE OWNER = 'MYUSER' AND TYPE_NAME = 'MY_TABLE'; As you know it's a collection type you can dig in a bit further with all_plsql_coll_t...
test-img

Alex Poole

Oracle AQ. Error ORA-25263: no message in queue when dequeue message

I want to dequeue message with message id from my queue table, but I get error that ORA-25263: no message in queue OPERATION_QUEUE with message ID DBF9DE01CB5C0DA7E0550000FF000001 How I can dequeue me...
test-img

oliaaa_s

oracle

oracle19c

oracle-aq

Votes: 0

Answers: 1

Latest Answer

Your message is in WAIT state, which means the message was enqueued with a delay > 0. It is thus not available for consumption yet. Once delay time expires, the message should become READY for cons...
test-img

user1612078

Loading a huge CSV file with high performance in Oracle table

I have a CSV File which its size is about 20 Gig. The file has three Persian columns. I want to load it to Oracle Table. I searched and found that sql loader has high performance. But, when I load the...
test-img

M_Gh

sql-loader

oracle19c

Votes: 0

Answers: 1

Latest Answer

Problem solved: I change the control file to this one: load data CHARACTERSET UTF8 infile '/home/oracle/test_none.csv' APPEND into table Fact_test FIELDS terminated BY ',' trailing nullc...
test-img

M_Gh

ORA-01002 Fetch Out of Sequence with Temporary Table and .Net

I have a stored proc in Oracle that I am trying to call from a .Net Core app. The proc loops through a cursor to populate a Global Temporary table, and attempts to send the result back as a ref cursor...
test-img

J.Cart

oracle

.net-core

stored-procedures

temp-tables

oracle19c

Votes: 0

Answers: 1

Latest Answer

So here's what I think was happening. The problem is that the temp table was defined with the attribute "ON COMMIT DELETE ROWS;", so when it ran on the DB side it was fine because there is n...
test-img

J.Cart

Posts

Questions

Blogs

Jobs