• Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 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:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Two Oracle 10g listeners running at the same time

    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?

    261715 pointsBadges:
  • SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    My procedure is shown below. When I execute it, it gives me the title error. Field3 is identified as a CLOB. Any / all help would be greatly appreciated. Running Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 CREATE OR REPLACE PROCEDURE xxx IS FileHandle SYS.UTL_FILE.FILE_TYPE; FileName...

    Bw75 pointsBadges:
  • Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?

    Hi all, My company' application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM, it's succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010. It's just opening the Excel...

    Wangakai5 pointsBadges:
  • Email attachment in APEX

    I was successful in sending bulk emails from an Apex application I developed to an email account on my hMail server but when the email reaches the account, all fields are delivered except the attachment. Below are the PL/SQL codes. Please, kindly help me check it through. Thanks DECLARE TYPE t_rec...

    Iyinoluwa70 pointsBadges:
  • BULK COLLECT and FORALL in PL/SQL

    How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

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

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