Hello, We are creating stored procedures containing htp.p commands to build html to generate web pages using Oracle Application Server (OAS) Obviously these...
... I don't know of a way to do this, but then I do not know Loader well these days. Can I kick off a stored procedure during my load process? If so, then ...
Hi, I'm currently trying to convert a programming team I'm working with over to XP and utPLSQL. However, one point of resistance is they very much like the...
... To test tax_server.users_pack.getusers, the package specification should be: CREATE OR REPLACE PACKAGE ut_users_pack IS PROCEDURE ut_setup; PROCEDURE...
Hi - I'm new to utPL/SQL and am having what I am sure is a simple problem. I have created a new package called ut_users_pack, which will test verious...
Hi there, unfortunately I do not know jLog or log4J ! But as far as I read the overview of these, I think you should check my PlsTrc application. It's...
... Have you seen PLVlog and PLVtrc, which are packages that are part of PL/Vision Lite, written by Steven? This was distributed with his book 'Advanced...
... Can you give some more detail about what jLog does? I'm unfamiliar with jLog (Steven may know more..) and searching for it on Google seems to pull back...
Guys, I believe that its reasonable to say the utPLSQL is at least partly based on the jUnit framework. Is there anything out there for logging in PL/SQL that...
Oh, yes - I forgot to say, for those that haven't seen it, the utPLSQL site is at http://sourceforge.net/projects/utplsql. It was set up a long while back, but...
I have made some changes to the SourceForge site: 1) I have disabled some of the features which are not being used, such as the mailing lists, forums and CVS....
You can download a patched version of utPLSQL 2.0.7 (also attached to this email) that fixes the following problem: * The AUTHID CURRENT_USER statement was...
... What version of Oracle are you running? In 8i and above, you should not have to specify a schema name if some_table is owned by the session running the...
Just digging in to really start to use utplsql for stuff other than utassert.eq and ran into this problem. This code in a test procedure: select count(1) into...
jeff621@...
Oct 29, 2001 6:46 pm
15
Pete Upton wrote that he created a test packed named ut_convert to test a procedure named utils.convert_currency. He followed all the naming convention rules...
Hello, I've just installed the latest version of the software. Package utconfig won't compile. Giving error 'On line: 246 PLS-00302: component 'DELIMITER'...
... The O'Reilly Site still has a few broken and/or out-of-date links on it doesn't it? Is there a reason why the SourceForge site was not pursued further? As...
... This is the Yahoo Groups home for utPLSQL: http://groups.yahoo.com/group/utPLSQL-Info You can then click on Files on the left hand vertical menu. You will...
Hello, I have joined the Yahoo utPLSQL group, However I don't seem to have a link to the Files section in utPLSQL-Info. Can anyone help? Pete ... From:...
pete upton
pete.upton@...
Oct 19, 2001 12:55 pm
9
... Whoops! The SourceForge site is not in use. I have uploaded the latest version (2.0.7) to the utPLSQL-Info Files section on Yahoo Groups. ... I have...
Greetings all, Just a quick question - I seem to have lost the original mailout(s) with utPLSQL 2.0 (alpha) zip. It also doesn't seem to be in the files...
Lachlan_Pitts@...
Oct 19, 2001 11:07 am
7
I have encountered a problem with eqquery - in certain circumstances it fails to run with error PLS-00402 "alias required in SELECT list of cursor to avoid...
... I think it may be nearly impossible to create such a thing, for the following reasons: 1) It is not possible to execute code in one form from another (they...
... That is a good and difficult question, perhaps two questions: 1 How can I unit test my stored code when executed from Forms? Well, one answer is: test them...
Steven Feuerstein
steven@...
Oct 15, 2001 2:40 pm
4
I'm in the process of being pulled out of my element as a Java developer into an Oracle Forms environment. I use JUnit as a practice. I've used utPLSQL on a...
jeff621@...
Oct 15, 2001 2:33 pm
3
It appears that Steven Feuerstein is being his usual, _humble_ self. The ultimate tutorial(s) on the language are any/all of his books on PL/SQL. However,...
Ken Hill
khill0@...
Oct 15, 2001 1:57 pm
2
... There is nothing outside of the current documentation set and example files. What trouble are you having?...
hello, Didn't see any posts here, but here goes. I'm having some trouble with the PL/SQL even though I've worked in five other lang. Any recommendations here...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
