• PL/SQL: How to use EXCEPTION statement before INSERT?

    Hi Experts how to use EXCEPTION statement before INSERT stm in PL/SQL Block Please help me with syntax or format is this option possilbe as well?

    Inprise610 pointsBadges:
  • pl/sql fixed file creation

    I am new to the pl/sql world. I'm ok with writing out a comma delimited file but I can't figure out how to write out a file where the fields are fixed length. I could use some examples. thanks,

    Bordenatemple5 pointsBadges:
  • Oracle (PL/SQL) fuction won’t work

    I'm trying to run the following script: function create_new_password (p_email in varchar2) return varchar2 as l_password varchar2(12); l_encrypted_password varchar2(32); begin select dbms_random.string('A', 8) into l_password from dual; l_encrypted_password := password_hashing(p_username =>...

    pforos220 pointsBadges:
  • How to convert LONG to CLOB or to VARCHAR type in select statement

    Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...

    SamG15 pointsBadges:
  • pl/sql code for email id validations

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

    Raffee5 pointsBadges:
  • Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following

    I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was substituted...

    Inprise610 pointsBadges:
  • Why can’t I connect to Oracle DB from virtual xp running under windows 7 host

    I am running plsqldeveloper on a windows xp virtual machine. (Created on a windows 7 box). When I start plsql developer on the virtual xp machine I type in a vallid Username/Password there are no Databases in the drop down list so I type in a valid database name then I get the following error:...

    PLSqlWannaB30 pointsBadges:
  • How can I generate an output file from two input files choosing data from each files using utl_file package or any other way?

    I have two html files one is a template with certain data that must be transferred to the output file and the other file is also an html file which contains the most data that must be transferred to the same out put file. I have tried to write from both files to the output file inside two loops....

    Techguys90 pointsBadges:
  • PL/SQL Query

    Create table other_sess( s_name varchar2(10)); insert into other_sess values('s2007'); insert into other_sess values('s2009'); insert into other_sess values('s2009'); commit; now i want to write a PL to retrive data from these sessions (s2007, s2008, s2009). from my current session. declare...

    FaheemNawaz15 pointsBadges:
  • search string in oracle DMP file

    hi , i would like to write a pl/sql oracle code to search a string from Oralce DMP file. e.g <OWNER_NAME>[strong]xxx[/strong]</OWNER_NAME> i want to get  [strong]XXX[/strong] as output . any help would be really really appreciated      

    Balajikalai15 pointsBadges:
  • Getting password when we know Product Code and Serial in Pl/SQL Developer

    Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

    PSRDOTCOM5 pointsBadges:
  • 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

    T Will5 pointsBadges:
  • Which tool is best in all aspects?

    Which tool is best in all aspects - speed, performance, user friendly, to do all activities etc - PL/SQL Developer or SQL Developer or TOAD

    RajeshITK65 pointsBadges:
  • Strip Tags HTML

    Is there any function to ignore html tags when conducting searches in a oracle table?

    Ged45 pointsBadges:
  • ORA-06550: line 224, column 7: error running in SQLPLUS

    Im getting the following error when running the code below: SQL> @n377d_load_tfdscpm_sxb.sql       exception       * ERROR at line 224: ORA-06550: line 224, column 7: PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following: begin case declare end exit for goto...

    Catch9315 pointsBadges:
  • write a PL/SQL block

    write a PL/SQL block that will prompt the user to enter the given employee number. It then print the employee last name, initials (first later of the first name) the department, location city and the number of years in active service.

    Njien20005 pointsBadges:
  • Doubt regarding EXCEPTIONS

    Hello, As the basic flow of a pl/sql block that contains a pl/sql block is like .... Suppose we have an anynomous block of code -------------------------------------------------------------------------------- Begin .... .... insert; update; delete; EXCEPTION ------Exceptions handled; END; /...

    Qqqq10 pointsBadges:
  • difference between t- and pl sql lang

    in both t-sql and pl/sql we can use if/else condition and jump into other statements..then actually what makes the difference between t- and pl sql lang?

    NidheeshPV5 pointsBadges:
  • Simply, How do I populate Fields from a SQL Statement in Oracle Apex?

    This is not a facitious question.  I am new to APEX.  I have looked over this stuff for weeks, but I can't find a way to run an SQL statement and populate text boxes. I have tried the famous "For C1 in (Select..." but, when I put it into any of the areas, the event never sets off.  I've tried...

    Ddape20 pointsBadges:
  • pl/slq procedures – POSITIVE and POSITIVEN as IN OUT parameters

    Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws a...

    Kanapo5 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