PL/SQL

"a program is trying to automatically send e-mail on your behalf" in D2k form

whenever i send mail automatically throug D2K forms&Report I get a Message 'a program is trying to automatically send e-mail on your behalf'. i t will ask for a confirmation yes or no' it goes every time to the user. now if user will click on no then this mail will not go. so i want pl/sql coding...

do_while how can i use do while statement to delete certain rows based on the rowcount?

how can i use do while statement to delete certain rows based on the rowcount??

PL/SQL - select data - group by- having?

I need to select all names where Value EITHER a or b. how do I do that?/thnks Sample: Num Name Value 1 Ann a 2 Ann b 3 Julia a 4 Julia b 5 Peter a 6 Jnohn b

IN PL/SQL how to declare and use 'STATIC DATA TYPE like C'

Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will...

I would like to know the procedure name

How to know the procedure name of itself? for example, ------------------------------ create or replace procedure my_proc1 is begin dbms_output.put_line (' procedure name =>' || xxxxxx ) ; end; ----------------------------- i want to print 'my proc1' as procedure name through ...

Inserting without duplicating

I need to create a row and to ensure that the row I'm creating does not already exist. I'm doing this in a pl/sql program.

job problem

i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => 'DropIp_test', job_type => 'plsql_block', ...

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...

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...

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...

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...

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 &...

pl/sql code for email id validations

i need pl/sql procedure that validates the email id is correct or not?

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.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES ...

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...

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?!

Truncate or not Truncate SQL

What are the pros/cons of truncate a table export/import to just drop table?

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

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?

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