My company is implementing an ERP system that uses an Oracle 10g database as its repository. Because this ERP system is being implemented across multiple companies, and because of upgrade and...
Please help,
I am attempting to create a trigger to fire a procedure but when I create the trigger I get:
Warning: Trigger created with compilation errors.
The procedure and trigger ...
as follows:
Monday, the Twenty-Fourth of May, 2009
TO_CHAR( 'fmDAY, DD MONTH, YYYY')
Its the DD part I need something else for.
Thanks!
Rolf
HI, I am new to PL/SQL. I have q question about append a ' in a string in the procedure.
The front end pass in an array which will contains value of 001, 002, 003, etc. I need loop it and ad...
Please suppose you have the string:
'4.5'
This string represents the number with integer part 4, and with decimal part 5. In Italy we use comma to separate decimals. With this SELECT s...
Hi,
here is my procedure -
PROCEDURE usp_read_xml_file
( par_file_name in VARCHAR2,
par_doc_name in VARCHAR2,
par_success ...
Hello all. I have a query where the user can specify the month and year of the data. These will be two separate parameters. I have tried all kinds of ways to do this. This is one of many a...
Hi,
I need to open and read a XML file on the server, parse it, and update a relational table on Oracle 10g using pl/sql (XMLDom).
An example of the xml file (test.xml):
<?xml version...
Hi, I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to...
Heres a simple query. The average can end up with decimal places what is the best way to round it up or down?
SELECT AVG(compensation) AS CompAVG, MAX(compensation) AS CompMAX, MIN(compen...
Hi Every one,
i need to find the table name from the schema( which has lots of tables in it) using column name.
like the column name is ' seriel_order '
and i need to find in which ...
HI, I have a question about array in Oracle.
The Front End (VB) send in an array, the procedure get it and loop inside to get a string , so I can put those string in a "IN" condition in my q...
I get this error when exceuting this pl sql procedure, which compiles good.
what i am doing wrong? the table exists and the query is good
I am using toad for oracle to retrieve data from oracle database. I am using a query using IN clause. I have to pass 4000-5000 parameters to the IN clause. Is there any solution. There is an ...
Hi Experts;
I need to run multiple select statement as one query from c# program, I add begin and end on both end, it gives me error as PLS-00428: an INTO clause is expected in this SELECT st...
Hi,
I have a field that accepts user input. This field needs to be validated for non-alphanumeric characters.
Is there a way to check for non-alphanumeric characters.
The oracle version ...
Hi, I have a question about comparing date in PL/SQL.
I have a query:
select * from table1 where TO_CHAR(eff_date,'MM/DD/YYYY') < TO_CHAR(CURRENT_DATE,'MM/DD/YYYY')
When I run this query, I...
Hi,
Is it possible to create a job to start on demand based on an existing program (PL/SQL)?
Thanks,
Hi All,
I want to be able to skip the first line that has header column titles and only start reading the data in the second line and onwards. How can I do this can someone please help me. ...
Hi Experts,
I am new to Oracle stored procedures and would like to add exception handling to some of mine I have already compiled. The attached stored procedure code takes a county number a...
I am developing an application with Java spring, hibernate and oracle and new to most of the technology. I have successfully used hibernate to interact with oracle tables with some help, but ...
I have a query which at times returns the result as a list of valuses.
My aim is to have each item that belongs to a subject to start on a new line.
The query returns the result as in the t...
Hi All,
Is there a way to set the current vlaue of the sequence in oracle 8i.
The issue, we have a sequence defined and used for one table primary key, but due to some intermediate inserts t...
I want read Unix environment variable in PL/sql script instead of passing to the sqlplus script, is there a way to do that?
In Oracle 10g PL/SQL, I have a delete statement in a stored procedure. It is not in a cursor. I want to see the number of rows I've deleted. I can use the dbms_output.put_line package. I sh...
