how can i resolve oracle error 00103
I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP.CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE...
View Answer
| Jul 11 2008 4:36 PM GMT
| asked by
15091974
PL/SQL, Oracle error messages, Oracle 9i
Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user
Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information.Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the...
Answer Question
| Jul 8 2008 7:04 AM GMT
| asked by
VB RD
PL/SQL, Database programming
How to capture emails with attachments from the POP server using Pl/SQL ?
I am able to retrieve emails from POP server using UTL-TCP package of PL/SQL. I am also able to retrieve Attachment with the email, but the contents of the Attachment are displayed as some random string of characters. Can anyone tell me how can I access the contents of the Attachment in...
Answer Question
| Jun 18 2008 5:06 PM GMT
| asked by
Monk
UTL-TCP, PL/SQL, POP server
What causes ora-00904 error on valid fields when querying across dblink in a cursor
I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the link and all...
View Answer
| Jun 12 2008 11:18 PM GMT
| asked by
Tom msu
ORA-00904, DBLink, Cursor
PLSQL based method to capture emails from POP server
I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server &...
View Answer
| Jun 5 2008 7:21 PM GMT
| asked by
Monk
POP3, PL/SQL, UTL-TCP
pl/sql code for email id validations
i need pl/sql procedure that validates the email id is correct or not?
View Answer
| Jun 4 2008 5:58 AM GMT
| asked by
Raffee
PL/SQL, Code, Email ID validation
Need help with a slow pl/sql script
Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ----------------------------------spool noaddressusagerelfix.LOGset timing on;SET SERVEROUT ON;DECLAREvpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE;vI_OCPOSTAD_USAGES ...
View Answer
| May 23 2008 11:00 AM GMT
| asked by
Darrankavanagh
PL, SQL, script
Pl/sql code for queries
Hi ,I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select...
View Answer
| May 21 2008 5:20 PM GMT
| asked by
User71408
Oracle developers, PL/SQL
Running Procedures within the PL/SQL program
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!
View Answer
| Apr 28 2008 10:53 AM GMT
| asked by
Nimsalwayz
PL/SQL, SQL Server stored procedures, EXEC
Truncate or not Truncate SQL
What are the pros/cons of truncate a table export/import to just drop table?
View Answer
| Apr 11 2008 3:37 PM GMT
| asked by
Jay Dog
PL/SQL, SQL
HOw to Find Duplicate Geometry in Oracle Spatial
If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me.A million thanks in advance...Regards,Sam
Answer Question
| Mar 18 2008 2:42 PM GMT
| asked by
SamAvella
SQL, Oracle Spatial, PL/SQL
Oracle listener
Hi all, can you help regarding oracle 10g listener?Sometimes for no reason i cannot log on int database, and then found there is two listeners running at the same time, do you know why?
View Answer
| Mar 13 2008 7:01 AM GMT
| asked by
2617
PL/SQL, Oracle 10g, Oracle Listener
ORA-06550 error: the function is undefined or not a procedure, yet I have defined the function
I get the following error message:ORA-06550: line 2, column 1: PLS-00221: 'CUSTOM_AUTH' is not a procedure or is undefined ORA-06550: line 2, column 1: PL/SQL: Statement ignored Error ERR-10460 Unable to run authentication credential check function.I have defined the function custom_auth
View Answer
| Mar 13 2008 1:24 AM GMT
| asked by
T Will
ORA-06550, Undefined Function, PL/SQL
Strip Tags HTML
Is there any function to ignore html tags when conducting searches in a oracle table?
View Answer
| Feb 15 2008 11:27 AM GMT
| asked by
Ged
PL/SQL, Oracle
insert and updat remote table
am using a trigger to sync a remote table every time there is an update or insert on the local table. The columns are user-type object.The tirgger can not insert or update on the remote table. I get the following error:CUSTOMERS Table : ORA-22804: remote operations not permitted on object tables...
View Answer
| Dec 31 2007 7:22 PM GMT
| asked by
T-REX
PL/SQL
Oracle table column names starting with a number
Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to keep the...
View Answer
| Nov 2 2007 0:56 AM GMT
| asked by
Jaime
Oracle, PL/SQL, Query
How to capture error stack when using forall in PL/SQL?
How do you capture all the errors in an error stack when using forall/bulk processing within PL/SQL?This is the error stack:ORA-12801: error signaled in parallel query server P000ORA-01722: invalid numberThe only error captured in PL/SQL is the first error message but the second is actually more...
Answer Question
| Oct 30 2007 11:58 PM GMT
| asked by
Rb plsql
Oracle, PL/SQL
my question
How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .
View Answer
| Oct 9 2007 4:35 PM GMT
| asked by
Maneswar
Parsing, SQL, PL/SQL
