Search results for query: *

I'm stumped...I have researched and tried different ways to resolve this without success. Hopefully someone can give me some ideas because I'm all out. I am trying to populate a REF CURSOR in a PL/SQL stored procedure so that Actuate 8 reporting software can access to generate a report. I can...

I am new to VB.NET. I am working with VS 2003. My issue is that I want to sort the current binded datagrid without going back to the database to obtain the records based on the new sort criteria selected by the user. Upon intially loading the datagrid was binded using a collection. Public...

It seems since we have upgraded to 10g (version 10.2.0.1.0) When executing batch jobs (to execute PL/SQL packages via SQLPLUS)the Oracle messsage ORA-28002; the password will expire within XX days is no longer appearing in the output log. I have done some research and the SQL*PLUS release...

I am interested advancing my career and becoming more marketable. I would like to start developing websites. I previously developed in COBOL now I am using PL/SQL. What do you suggest I learn first HTML, XML, or some other language?

Using DOS is there a way to obtain a (line count or record count) of a .DAT file. For example if I append two files together I would like to know the resulting total record count of appended file. Thanks in advance...

I have WINDOWS 2000 PROFESSIONAL with WORDPAD V.50 (service pack 4) software. Is there an upgrade or utility that can provide me (the line number and character position) within a file where my mouse cursor is pointing? For example: I open a raw data file into WORDPAD containing 10 records. I...

How do I stop rounding in the below CTL for the TOTAL_AMOUNT field? Tried using ZONED DECIMAL but that did not work. Tried using no datatype (as shown below) and that did not work. Fields coming in (used in adding)are loading into the table correctly. In the database table the field is defined...

I receive a text file from another site which contains negative values. The problem is that the negative sign is in a fixed position in the file not floating. Also within a single record the field values can be either positive of negative. I currently have a CTL that would load the file...

I have a SQL*PLUS command in a .bat file and want to know if a .sql script file is the only way to execute a PL/SQL procedure. For example. Could the below work ?: sqlplus username/password@databasename execute instancename.procedurename; WHAT WORKS: The procedure executes if the execution...

We are currently converting an old COBOL based application to ASP.NET. My task is to re-write a COBOL unload program using PL/SQL. The program extracts text as well as numeric fields from the database and writes several fixed length files. Everything seems to be working well except to convert...

Can I create a PL/SQL procedure which then calls another PL/SQL procedure (needs parameters). I have been looking and trying different commands but none of them seem to work with out this error or some other error. PLS-00201: identifier 'MAILUSERS' must be declared MAILUSERS is the procedure...

I am a beginner PL/SQL programmer. I am trying obtain fields from a cursor, fetch them into a record and write the record out using UTL_FILE.PUT_LINE(filehandle,string) I can't compile the below without getting an error: PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'. Where...

I am a beginner a ASP.NET currently a COBOL programmer. I am not sure I understand why custom classes need to be created. Is there some sort of criteria that determines why a class should be created instead of just coding all the logic in the form's code behind. Does creating class make the...