Simply pass the different numbers in a string with each number separated by commas. You then append a beginning and ending comma to the parameter so that it becomes ",123,456,789,". Then you convert the database value to a string and apply the commas to the beginning and end also...
I have been writing a reasonably complex Excel VBA routine to produce a report on one worksheet from particular data found on some of the other worksheets in the workbook. Two weeks ago, after about 10 hours of work, I almost had it completed, but I decided to put it away for the Xmas vacation...
I'm trying to generalize a listbox clear/select all items routine. First wrote the clear all and select all items routines, but the only difference is that the Select(iItem) is set True for Select and False for clear. So I wrote a Toggle All Items routine with parameters for the Listbox and...
Thanks,
In Oracle 7.3.3 I only had to run CATPROC.SQL, in Oracle 8, when I ran only CATPROC.SQL I got privilege errors when I tried to log into SQLPLUS, so I followed an example that only showed PUPBLD.SQL and got the above error. I'll give this a try.
Thanks!
I need to look around that site more.
It could just be me, but a lot of the information at the tech-sites seem to be down "twisty turny tunels -- all a like", so you practically have to know the answer to find it.
It would be funny, if when you clicked the site-map you go...
Today, I created a small database on a Silicon Graphics system using Oracle 8.0.5, but when I run SQLPlus and login I get the following error:
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
This is the first time I've...
My appologies to any who might have seen this on the other Oracle list, but I didn't know there was a list for 8 too.
Unless I'm mistaken the uninstallation option provided the Oracle Installer only adjusts entries in the registry and removes the shortcuts, but doesn't completely remove all of...
Today, I created a small database on a Silicon Graphics system using Oracle 8.0.5, but when I run SQLPlus and login I get the following error:
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
This is the first time I've...
Unless I'm mistaken the uninstallation option provided the Oracle Installer only adjusts entries in the registry and removes the shortcuts, but doesn't completely remove all of the Oracle related registry entries, files, and directories that Oracle installed. This is fine if you want to upgrade...
When I run reports using Crystal Reports Web-Server it prompts me to log into each table used in the report seperately. I know I can pass user#=<username>&password#=<password> parameters for each table, but since all of the tables are in the same database and I only want...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.