Thursday, May 14, 2009

XML output from PLSQL procedure

declare
out_file Text_IO.File_Type;
v_loca varchar2(100):='D:\PBM\Outward\';
begin
out_file := Text_IO.Fopen(v_loca'Outward''.xml', 'w');
Text_IO.Put_Line(out_file,'');
Text_IO.Put_Line(out_file,'');
Text_IO.Put_Line(out_file,' ');
Text_IO.Put_Line(out_file,' ');
Text_IO.Put_Line(out_file,'''070''');
Text_IO.Put_Line(out_file,'
');
Text_IO.Put_Line(out_file,'
');
Text_IO.Put_Line(out_file,'');
Text_IO.Fclose (out_file);
end;

Oracle Forms or reports 6i in Windows of 64 bits

Oracle Forms or reports 6i in Windows 64 bits

Oracle Forms for Windows is not certificate for any version of 64 bits (Vista Windows, Microsoft 2003/2008 Server). What is not certificate does not mean that it does not work, simply that Oracle in case of problem is not going to provide any type of support.
Vista Windows of 32 bits is not certificate but in particular from the beginning it has given less problems me than Forms10g, but Oracle Forms 6i in 64 bits from patch 4 does not work the calls to reports that they are realised from forms, either works from Forms Builder to execute the form that we are designing.
Since I have said the problem before arises from patch 4 from forms, with previous patch 3 or it works perfectly, but there are cases like mine where already it was using patch 17 where we cannot raise to return to the 3 since more things would fail many to us.
The problem in particular is in the bookstores nn60.dll and nnb60.dll that is in folder BIN. These bookstores I believe that they manage the communication between applications of Forms, forms with reports, to builder with debugger, etc.
In my case I have installed patch 17 and I have put those bookstores of patch 3 and works everything correctly.
In the following connections I leave the bookstores of patch 3, so that if teneis problems simply renombrais those that teneis installed and copiais these:
nn60.zipnnb60.zip
-----------------------------------------------------------------
Pls try to replace the following two dll files in \bin folder by using oracle 6i patch 3 or before version:
nn60.dll
nnb60.dll

You may download the two .dll files from

nn60.dll
https://www.sugarsync.com/pf/D6290988_0562627_631503
or
http://66.163.168.225/babelfish/translate_url_content?.intl=us&lp=es_en&trurl=http%3a%2f%2felfeme.googlepages.com%2fnn60.zip


nnb60.zip
https://www.sugarsync.com/pf/D6290988_0562627_631515
or
http://66.163.168.225/babelfish/translate_url_content?.intl=us&lp=es_en&trurl=http%3a%2f%2felfeme.googlepages.com%2fnnb60.zip

For more information: http://kr.forums.oracle.com/forums/thread.jspa?threadID=603065

Installing Oracle on Solaris 5.11

Installing Oracle on Solaris 5.11 is painless
except before you ./runInstaller you have
to edit the ./install/oraparam.ini and change line 42 to
something like:
Solaris=5.8,5.9,5.10,5.11

Then it will pass the first check and continue with install.


or

$ ./runInstaller -ignoreSysPrereqs

$ sh runInstaller -ignoreSysPrereqs