1
  • 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:
  • $$PLSQL_UNIT

    Dear All, I know that using the $$PLSQL_UNIT, I can get the current procedure executing. but there is a problem when i use it to get the procedure name inside the package. it only returns the Package name not the procedure name. How can I get the PACKAGE.PROCEDUE_NAME? Please help. Ahmad Saeed...

    AhmadSaeed5 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:
  • calling reports in pl/sql code

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

    P0095 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 – 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 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:
  • 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:
1

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.

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

Following