Oracle Graphics - Urgent - Forms

Hi,
Through a Batch File I am calling the Graphics(GORUN60.EXE) and
exporting the output as .CGM file. In which s/w can I open this
CGM file. I am not able to Insert into PP or Word.
Immediate suggestions required.
Thanks

Related

How to read the data file and write into the same file without a temp table

Hi,
I have a requirement as below:
-------------------------------------------
We are running lockbox process for several business, but for a few businesses we have requirement where in we receive a flat file in different format other than how the transmission format is defined.
This is a 10.7 to 11.10 migration. In 10.7 the users are using a custom table into which they are first loading the raw data and writing a pl/sql validation on that and loading it into a new flat file and then running the lockbox process.
But in 11.10 we want to restrict using temp table how can we achieve this.
Can we read the file first and then do validations accordingly and then write to the same file and process the lockbox.
Any inputs are highly appreciated.
Thanks & Regards,
Lakshmi Kalyan Vara Prasad. 
Are you talking about the new global temp table? What's the reason for restricting its use?
Ben 
Can we read the file first and then do validations accordingly and then write to the same fileUsing what? UTL_FILE? No. You can't open a file for read and write at the same time.
But I don't get why you want to load the file and write it out again. Once you load it, why not process it as a table? 
Hi,
Thanks for the response...
In 10.7 they are creating a normal temporary table and uploading the data file and then they are validating it and after that they are writing into a flat file and processing it.
In 11.10 they doesn't want to create a tempory table because it result in user performing many steps... They want me to write a program unit in which i can read the data file and do the necessary validations there only and write back to the same dat file and then complete the process.
Thanks & Regards,
Lakshmi Kalyan Vara Prasad. 
Hello Gurus,
Let me tell you about my requirement clearly with an example.
Problem:
------------
i am receiving a dat file from bank in below format
105A371273020563007 07030415509174REF3178503 001367423860020015E129045
in this detail 1 record starting from 38th character to next 15 characters is merchant reference number
REF3178503 --- REF denotes it as Sales Order
ACC denotes it as Customer No
INV denotes it as Transaction Number
based on this 15 characters......my validation comes.
If i see REF i need to pick that complete record and then fill that record with the SO details as per my system and then submit the file for lockbox processing.
In 10.7 they created a temporary table into which they are loading the data using a control file....once the data is loaded into the temporary table then they are doing a validation and updating the record exactly as required and then creating one another file and then submitting the file for lockbox processing.
Where as in 11.10 they want to bypass these temporary tables and writing it into a different file.
Can this be handled by writing a pl/sql procedure ??
My findings:
----------------
May be i am wrong.......but i think .......if we first get the data into ar_payments_interface_all table and then do the validations and then complete the lockbox process may help.
Any suggestions from Oracle GURUS is highly appreciated.
Thanks & Regards,
Lakshmi Kalyan Vara Prasad. 
I hope you must be doing these steps manually, i.e creating a temp table, then reading the file separately, loading data to the temp table and then validating, then dropping the temp table etc etc.
All these, if done manually would be really tedious, thats why your customer dislikes this process.
But why cannt you write a single script(May be a perl or a simple PLSQL script)
I would write a perl script which does the following.(say lockboxValidation.pl)
1)-Create a temp table using perl DBI.
2)-Read the file in the Operating Syatem(Must bne placed somewhere).
3)-Parse the data and put them into the Temp table.
4)-validate from the temp table data.
5)-Write back to the same file with same name in the format(Overwrite the old file with new contents).
6)-Drop the temp table.
Just run this program from your Linux/Unix/Windows server and done..The customer cannt see whats happenning inside as it will automate the process.
You can also avoid the creation of the temp table if you are comfortable in perl to
1)-read the file from the File System in perl.
2)-Use perl's Reg Expr to parse the data and validate.
3)_write back to the file.
This should be very simple without any intermediate objects getting created. 
Hi Amulya,
Thanks for your comments....if you could provide me scripts related to this, it will help me a lot, as i am not aware of PERL scripting.
Could you please pass the coding for the same.
Thanks & Regards,
Lakshmi Kalyan Vara Prasad. 
I dont know how is your data format is. But this is fairly simnple. Ask any of your DBA or whoever is good in shell scripting can do this.
Alternatively, if one knows a little of Java programming can also do this.
The same steps to be done in Java.
Using JDBC write a small program to create a temp table.
Using java.io.FileReader and java.io.FileWriter, read the file, parse the contents and validate. Then again write to the file in the same format in Overwrite mode.
Anybody who knows the java.io programming and little of String manipulation can achieve this.

Append spool file

Hi friends,
i am using oracle 9.2.0.4.0. Totallly i have 9 instances (5 in windows 2000 and remaining in linux)... I need to take some reports from my all databases weekly basis... i dont have idea to append the results into spool file. Can you please give me the idea to create single output file instead of nine files? (Can i append the all the result into single file is any option?) please guide me...
Regards,;
Karthik 
There is an option available in 10g. I don't think such option is available in 9i.
Regards,
Satheesh Babu.S
http://satheeshbabus.blogspot.com 
No, you can't, if you try to reopen a spool file with the same name, contents will be overwritten.
You can create a shell script that appends everything at the end of the process and delete the spool files of each database. 
Can this help for you ?
Re: spool/save append?

display blob with forms6i

Hi,
i thought it would be easy ti find how to do it nut from searching this site and with google i couldn;t find the answer for that.
i have blobs in a table (jpg,doc,pdf ...) .
how can i display those blobs (jpg,doc,pdf ...) in forms6i ?
can you give me step by step how to .
thanks allot for any help
Zvika 
You can display a jpg image in an image item. But you cannot directly show pdf in Forms (like you do with a plugin in a browser). You can put the file on the file system and then open it with a HOST command or the DDE package.
This is an example from the online help:
/*
** Start MS Excel with spreadsheet emp.xls loaded
*/
DECLARE
  AppID  PLS_INTEGER;
BEGIN
    AppID := DDE.App_Begin('c:\excel\excel.exe emp.xls',
     DDE.App_Mode_Minimized);
END; 
Hi ,
can you tell me how to get the blob (pdf,doc etc) and extract it to the operating system so i can open it with host command ?
10x
Zvika 
Actually, my first answer was not complete. You can probably use an OLE item. Look for examples in the online help (I haven't got Forms here right now). 
maybe this thread can help you.
Re: How to store a "word document" on Data Base? 
Hi,
i don't need to store the blob.
i already did it without forms.
now i have blobs (pdf ,docs etc) in my database.
i want to display them that's all.
i didn't think it will be a problem doing so :-(
anyway my problem is displaying the blob .
10x
zvika 
hi guys
can someone help me with this 
Hi,
How can I open different binary files from BLOB column ?
Hope it helps.
Jose.

WITH OUT USING SQL*LOADER

Hi All,
can any one please help me for this issue - how to load excel data into oracle database table WITHOUT USING SQL*LOADER ...............
Thanks.. 
SQL Developer 
hi,
Refer to : http://blogs.oracle.com/warehousebuilder/2010/03/loading_an_excel_spreadsheet_into_an_oracle_table.html
- Pavan Kumar N 
You can not use utl_file to read the file and create the insert staments because you have oll header lines and format characters if read excel as text file.
You can use a macro or formula in the excel to create text plain file with the inserts and execute it. 
Convert the Excel file into a CSV (or other delimited) file and use EXTERNAL TABLES - http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/et_concepts.htm
Srini 
http://blogs.oracle.com/warehousebuilder/2010/03/loading_an_excel_spreadsheet_into_an_oracle_table.html
http://www.excel-db.net/oracle.htm 
826854 wrote:
Hi All,
can any one please help me for this issue - how to load excel data into oracle database table WITHOUT USING SQL*LOADER ...............
Thanks..Why is sqlldr not an option? There are other possibilities (some already mentioned, some not). Without know why you seem to have this particular restriction, it is impossible to suggest a best solution. 
Most likely a question asked in an interview or a quiz/test
Srini

Re: CTRL file issue

Hi All,
I have created an control file which will append the table by reading the data from the dat file. The dat file contains heading as well. Everytime when i append data to table, the heading also inserted as a row in the table.
If i manually removed the header row from the file, the insertion working fine. As we received the file from external system we are not in a position to request the client to send the dat file without header.
Without using Shell script is there a way to resolve the issue by using oracle control file itself.
Please help me to resolve the issue.
Regards,
Sathya 
Sathyaseelan wrote:
Hi All,
I have created an control file which will append the table by reading the data from the dat file. The dat file contains heading as well. Everytime when i append data to table, the heading also inserted as a row in the table.
If i manually removed the header row from the file, the insertion working fine. As we received the file from external system we are not in a position to request the client to send the dat file without header.
Without using Shell script is there a way to resolve the issue by using oracle control file itself.
Please help me to resolve the issue.
Regards,
SathyaYour question is not really clear, I assume you are using sql loader to load the files; You can use the option SKIP read this document: http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_skip_header_records_while_loading.3F
If you are using External tables you can also use the option SKIP 
Thanks for the guidence

Categories

Resources