• Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched

    Hello, I am using "Toad for Oracle" and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to do it using a query or to create a...

    Dug50 pointsBadges:
  • 4 to 5 sql statements in procedures

    I want to create 5 sql statements in one procedures which are performing diff tasks. can u provide the pl/sql PROC which can be include 5 sql statements.

    0 pointsBadges:
  • Oracle stored procedure error with PL/SQL

    We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...

    BrentSheets6,925 pointsBadges:
  • calling reports in pl/sql code

    how to call reports 6i report from pl/sql code procedure in pdf format

    P0095 pointsBadges:
  • Invalid objects after upgrade from 8.1.7.4 to 10G

    for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN...

    DBAKim5 pointsBadges:
  • What is the difference between software package in SQL and PL/SQL

    why is the need of psql when the sql is already avaliable.

    Krrishkundan5 pointsBadges:
  • NEED HELP to DETERMINE STEPS to TAKE when going from 9i to 10g in terms of plsql best practices as well as known issues to watchout for

    Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3) known...

    MaxonIT11595 pointsBadges:
  • DDL in PL/SQL procedure

    I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.

    Binwal5 pointsBadges:
  • PL/SQL

    Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it...

    Inprise610 pointsBadges:
  • PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take NULL but...

    Inprise610 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

    Inprise610 pointsBadges:
  • PL/SQL error

    Hi Experts, I am getting the follwoing error ORA-08102: index key not found, obj# 141051, file 28, block 15245 (2) I tried rebuild on that specific obj id still error persist wat are the possible causes and how to overcome please guide me

    Inprise610 pointsBadges:
  • PL/SQL Insert

    Hi Experts, I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction and my first insert is successful while doing the insert on second table which is completely carry same set of attibutes and values of 1st table + 1 additional static value attribute,it gives ORA :01400 error...

    Inprise610 pointsBadges:
  • INSTR ()

    Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error( err_pkg.nt_val, err_pkg.nt_val_msg ||...

    Inprise610 pointsBadges:
  • How to write a test case in PL/SQL

    Hi Experts, How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure If(emailadd) <> lower(emailadd)then raise_app_error_ But this can be checked n test case please guide me with pseudo code...

    Inprise610 pointsBadges:
  • pl/sql procedure ,urgent!!!

    How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE...

    Ecsbc35 pointsBadges:
  • Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables

    Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an...

    Ejpeth15 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
  • How to implement Sleep logic not using sleep() need customized

    Hi Experts, I need to implement a sleep logic in a loop i need to check for SELECT/INSERT stm if it s locked by other user i will go to sleep mode then back to earlier savepoint position eg savepoint x; INSERT/SELECT i need to check for 10 times each time sleep is for 1 sec i applied counter i...

    Inprise610 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following