• Code coverage tool suggestion for PL/SQL

    Hello, we will use a code coverage tool for PL/SQL and have been looking for the best tool. I am wondering if you people can suggest any tool. Would you please write the reason why you selected it?  Sector is financial, if it helps and it doesn't matter if its open source or not. Thank you.

    merkancam5 pointsBadges:
  • Advise in shifting from Iseries to PL/SQL developer

    Hi, Currently, I am working in Iseries and have 3.5 years of experience as RPG and CL developer. Now, because of the shrinking usage of Iseries I am planning to shift my profession as PL/SQL developer. Could anyone advise whether it will be a wise decision to continue my profession in Iseries or...

    asastr0915 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:
  • Is PL/SQL a right choice form performing operations on a databse and display the final result.?

    I am developing a stock maintainence software using java language (Front end) and using oracle database as backend . i am storing data entered into some sort of gui builded forms into database. Now i want to perform some operations on that data and then display the final result. Is PL/SQL a right...

    hussain22juzer530 pointsBadges:
  • Excel File from PL/SQL Procedure

    Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather

    HeatherM5 pointsBadges:
  • Error(31,19): PLS-00103: Encountered the symbol “INTO” when expecting one of the following

    I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able to help...

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

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