I have databases in two locations.
in db 'A' I have a table called PEOPLE
in db 'B' I have a materialized view called PEOPLE which is selecting rows from PEOPLE@'A'
I added a column to t...
I am getting the error: ORA-00911: invalid character; ORA-06512: at line 18
I cannot figure out what is wrong with the execute immediate statement. Any ideas?
BEGIN
FOR rec IN (SELECT ...
Hello Experts,
I am having a problem with Blobs. Ultimately I am looking at inserting images into a table, they need to be in the format of a blob.
However, at the moment I am having tro...
I have an function in PL/SQL that should return XMLType (see below). How can i convert DBMS_XMLDOM.DOMNode to XMLType?
I have a stored procedure that is being called in a loop for emailing.
When I run the stored procedure, after emailing about 180 times, I am getting the below error -
ORA-30678: too many o...
The challenge here is to establish the number of weeks that have elapsed between two specified dates. A week number can easily be returned using the IW format (seel below)
SELECT TO_CHAR(T...
I need to dump a table from an Oracle 10i instance that stores a lot of text in a BLOB field. Is there a quick way for me to do this using SQL Developer?
Thanks,
Matt
I am using Oracle SQL Developer 1.5.1
Trying to get this trigger to work but it wont work its really eating my brain.
One error saving changes to table "KITS"."INVOICESX":
Row 1: ORA-04...
I have produced a query and the WHERE clause in the SELECT statement is say:
WHERE cust_id = 1
This works ok. But I want the user to be able to type in the 1 or whatever number he wishes. So...
I have made a function to create check digit using mudulus 11 method.
Its working fine except for some numbers, like 116 , numbers which have same digits repeating like 1 in 116
How can i...
I have a table in which there is a identifier against which I have email address. Now there can be multiple entries for a identifier. Example
a,a@b.com
a,b@b.com
a,c@c.com
b,m@b.com
b,k...
How can i retrieve the result of a given fucntion in pl sql called from a java class??
I am using select max(date) in a subquery and it is taking a while to return the results of the query. The amount of records that is being return are approximately 17,000 records. Is there a...
I have a table that has a date column. Sometimes an invalid date is passed and I'd like to capture and initilize the incoming value to null and have it inserted without error. Currently I ge...
Hi,
I have created an Trigger which fires whenever a record is inserted into my table.
This trigger in turn calls a stored procedure in a package called 'GENMAINTENANCE.pkg_mch_queue'.
...
I am writing a procedure to loop through a list of 'teams', then Select old data for each team and insert it as new data with new values. The general logic works, but when I add error handlin...
I am creating the trigger to insert the record in the Instace_contact table when instance is created. I am getting PLS-00049: bad bind variable 'NEW.DB_INSTANCE_CONTACT_SEQ error
Hai !
i want to select the data from a collection - something like this.
declare
type tab_col is table of number;
num_table tab_col;
total_count number;
begin
for i in 1..10 loop
...
I am trying to extract the organizationID element value from the xml below and i am unsure of how to supply the namespace syntax and its driving me crazy.
<s:Envelope xmlns:s="http://schema...
How come the following runs, but when I add parentheses around it, oracle developer gives me the error "ORA-00907: missing right parenthesis, error at line: 11 column:1." Be gentle, I am stil...
I am trying to create a package that calls another package and the indiviual procedures in the package.
I have a situation where I need to have the ability to get one row in random from the result set of another nested select statement.
The random row that I want returned must be between 1 an...
Please help sdstuber
What I mean by a generic csv reader is that when the PLSQL code is reading the data it might start of identifying that the first comma is at position 6 (meaning that the ...
Below are the errors I keep receiving trying to create the sequence and the Trigger code is below the errors. What am I doing wrong?
Error(8,2): PL/SQL: SQL Statement ignored
Error(8,9): P...
Hi,
I'm writing a stored procedure to export tables using the Datapump API but it seems to be barely doing anything other than produce the two files, which the log file is empty and the dat...
