I am trying to search an Oracle 10g R2 database and see if a particular user has any records.
So first I need to get a list of tables that have columns named 'USER_ID'
SELECT table_name FR...
The attached procedure is called in an oracle form using sqlplus..
I would like to be able to pass the contents of the x_part_number variable to the part_numbers.txt file.
Whenever I use the...
There is a table I'm trying to query against that it setup like this:
Column Name Type COLUMN_ID
car_id number 1
product_id varchar2 ...
I need to be able to test if a specific file exists from within PL/SQL.
We run TOAD (9.7), Oracle 9ir2.
I would like to keep everything "inside" Oracle if I could.
I think I could do somet...
Hello,
I am working with Oracle 10g. I have installed the client on my workstation and now I am trying to use TNSPING to test the connections in my TNSNAMES.ORA file.
When I try to use ...
i have written a procedure at database level in oracle(10g). the procedure has lot of insert and update quries. I want to define exception so that if any of the update/ insert command fails it...
I am getting the below exception when i try to get the cursor from store procedure
java.sql.SQLException: Cursor is closed.
at oracle.jdbc.driver.T4CResultSetAccessor.getCursor(T4CResultS...
I am getting problem, while getting a value from sequence from oracle9.2
ORA-02287: sequence number not allowed here...
so how to get the value from a sequence by using SELECT query & how to...
Hi,
I'm trying to create a table from another table using execute immediate. When I run the sql it works fine but when I build it into a package I get an ORA-01031:insufficient privileges me...
Hi,
I have a weird problem. I have a Java program that is getting a Connection, setting the autocommit to false, Executing a stored procedure in which I am updating a record. And in later ...
Experts, how do I use the replace function to replace an Enter key stroke with a space or a carriage return with a space. I need to use the ascii equilavent correct? Here is what I tried and...
I get the error message
{"ORA-06502: PL/SQL: numeric or value error: character string buffer too small\nORA-06512: at \"package_name.proc_name\", line 370\nORA-06512: at line 1"}
when I...
Hi,
I have inserted the value like 6½ x 6. But when i am selecting the data it comes me like 6¿ x 6. I am inserting data to my server database. I am selecting the data from client machine....
Hi folks,
I'm trying to write a stored procedure in Oracle PL/SQL that'll return a recordset. I need to be able to view the results in a grid within my application.
Can anyone help me w...
Hi Experts,
I've got this error while running one of the package. How to resolve this. we got ORA-02049: timeout: distributed transaction waiting for lock during commit process. As my under...
This is the control file i am using to load into multiple tables. But, it is loading only into one table table1. Please suggest. I have copied the sample data into code block.
LOAD DATA
AP...
Hi all,
I have writtent he following CASE Statement in the
criteria for DeptID
DEPTID =
CASE :1 WHEN '12345'
THEN '555111' END -- This works and brings back the specified departm...
I have to convert a HEX value (stored in a column with type varchar2) to binary
how can i do this in PLSQL?
CHBK_STAT VARCHAR2(50)
suppose the HEX value = DBBFFE80
its binary will...
I'm trying to create a procedure that retrieves from a table, the register with the highest value (without using Max() function :) )for certain field, but i keep getting an error:
CREATE OR...
I have the following info that gets spit out if you only run my query that is in my having clause. And I know I'm on the right track its just right now my whole query returns nothing. Howeve...
Hi all,
I have 1 sql:
select distinct t.SETTLEMENT_DATE from t
t.SETTLEMENT_DATE: char()
Result of this sql: 6/16/2008 12:00:00 AM ...
Hi,
I have a stored procedure in Oracle that is baffling me. I have one table, let say called MASTER and a second table called SOURCE. As there is a lot of data being processed I run a comp...
I need to write a function such that it will have an insert statement
and this function should return the number of rows inserted into the table. How to do that?
My table name is my_table...
HI,
I have an requirement as follows
1 . i am getting all the applicable columns from a function.
2 . currently i am following an approach like
execute immediate 'insert into ...
Hi, I have question about PL/SQL.
I need modify or create a new query. The old query populate a list contains charts and I need to add one more condition.
There is a array parameter will...
