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 [...]

Answer Question   |  January 28, 2013  8:36 AM
PL/SQL, PL/SQL attributes

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 shift my [...]

Answer Question   |  November 22, 2012  2:04 PM
iSeries, PL/SQL

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 choice for [...]

Answer Question   |  July 3, 2012  6:01 PM
Java, Oracle 10g, PL/SQL

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,

Answer Question   |  October 28, 2011  12:48 PM
PL/SQL, SQL

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 => upper(p_email), p_password => l_password); update customer set encrypted_password=l_encrypted_password where upper(customer.email)=upper(p_email); return l_password; end; and i’m getting the following error: Error at line 10: PL/SQL: [...]

Answer Question   |  June 6, 2011  8:53 PM
APEX, Oracle, Oracle Apex, PL/SQL

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 open the Excel file but no data [...]

Answer Question   |  May 25, 2011  8:41 AM
excel, Oracle Forms, Oracle Forms 6i, PL/SQL

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

Answer Question   |  March 26, 2012  12:44 PM
excel, Oracle 10i, Oracle PL/SQL, PL/SQL

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 [...]

Answer Question   |  November 4, 2010  9:20 PM
Oracle 10g, Oracle 10g administration, Oracle PL/SQL, PL/SQL

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 mold_session varchar2(10); cursor c1 is select s_name from other_sess order by s_name; begin open C1; loop [...]

Answer Question   |  October 25, 2010  5:31 AM
PL/SQL, PL/SQL Multiple Session, SQL Query, SQL tables

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      

Answer Question   |  October 15, 2010  12:01 AM
DMP Importing, Oracle, Oracle PL/SQL, PL/SQL, Search string

External Table / SQL Loader
Hi, We are using this new sqlloader for a month nowmand it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge error KUP-04001: error opening file [...]

Answer Question   |  March 14, 2012  2:50 PM
PL/SQL, SQL Loader, SQL Server

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.

Answer Question   |  March 29, 2010  1:44 PM
PL/SQL, PL/SQL block

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; / ——————————————————————————– Now …i know that all the DML’s is goin to execute in a sequence. Now if my [...]

Answer Question   |  March 25, 2010  8:51 PM
PL/SQL

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 if loop mod null pragma raise return select update while with <an [...]

Answer Question   |  April 7, 2010  1:13 AM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution

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?

Answer Question   |  February 10, 2010  4:23 AM
PL/SQL, T-SQL

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 [...]

Answer Question   |  January 20, 2010  8:10 PM
Oracle Apex, PL/SQL, SQL, SQL statements

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 [...]

Answer Question   |  November 12, 2009  7:49 PM
Data Types, Oracle, PL/SQL

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 or UPDATE statement O_N_L_Y. [...]

Answer Question   |  April 19, 2011  8:00 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL

About Time
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet  

Answer Question   |  October 27, 2009  6:03 AM
OC, Oracle, PL/SQL, SQL, SQL Server

SR in oracle(tickets)
Can u please give me a list pf SR’s u have solved ?

Answer Question   |  August 18, 2009  6:22 AM
Oracle Service Request, Oracle SQL, Oracle SR, PL/SQL