Search results for query: *

I was looking for a way to use the database connection wizard in express 2008 vb.net. It wouldn't let me add the MySQL service. Also, it only gave me 3 database options to connect to, none of which was MySQL. Help. Greg

I set a MySQL 5.0 configured instance on my machine a few months ago and did nothing with it. I set a password and now I can't remember what it was. Is there a backdoor method getting it. I tried uninstalling the whole thing and setting it back up but when I got to hte password portion it...

I want to develop and deploy an inventory app using SQL server. I have worked with it before but never really deployed it as a single licence/deployment package? What do I actually need for that. I have MSoft SQL Server 2005 on my computer. THen it reads configuration tools. It doesn't seem...

I am creating some inventory tracking software. simple but the problem is if I wanted to install this on another computer that doesn't have the same database software, what are my options. I really don't want flat file and I would like to package this thing in one deployment. IS there any...

I am running code on an oracle 9i database. The two areas that I have been developing in have recently crashed with this error: ORA 01034 Oracle not available ORA 27101 Shared memory realm does not exist I am not as much a pessimist as I once was but it seems that I could be doing something...

This code does 3 things is cshell. It changes the SES_ID_INPUT, OUTPUT_FILE_NAME, and test text in an sql file prior to running it. So far I been unsuccessful in trying to trim this down into one statement. cat gen_query.sql | sed 's/ SI'/SES_ID_INPUT/'$SES_ID'/'>junk cat junk | sed...

I am trying to write a script that searches a file, finds a marker like 'test.txt' and replace it with a new file name. Someone today mentioned to me the 'sed' function. It looks extremely flexible. So flexible that I would need help in writing it. Thanks Greg

Is there a way to call external functions from another pl/sql script besides packages? Say I have a single plsql file that multiple scripts call to use its functions, or something of hte like. I KNOW that ideally packages would be the way BUT, does anybody know a work around? Greg

I am working on a unix box and have found the need (desire) to change the font for headers I have been printing. My nedit editor cannot change fonts. Is there a way to do this with UTL_FILE. I have not found anything on the web. Thanks, Greg

I have a cursor with 5 'OR' statements in the where clause. I am looking for 5 different data values. But I need to know that I am going to receive one specific one first. Say if field 5 of the 'OR' statements is the one I know I need first before I can evaluate any of the other ones. Or if...

SUBSTR(string,<i>,<j>) i is start point joint is length from start point. I have been reading on this and SUBSTR is supposed read from back of string when the <j> portion is negative as long as the <i> portion is not 0 or negative. My code: set serveroutput on size 2000 DECLARE s1...

I have an explicit cursor that normally looks for a payload value to be = 1 as an input. Occasionally the input will be a 0. This will change the output of the search. But even more occasionally there is a need for both values. The payload field itself is either 1 or 0. I was wondering if...

1 create or replace directory temp as '/home/marting/test'; 2 Declare 3 l_file utl_file.file_type; 4 strbuffer VARCHAR2(32767); 5 mynum number; 6 7 Begin 8 l_file:=utl_file.fopen('temp','Cimteet.txt','R'); 9 utl_file.get_line(l_file,strbuffer); 10 END; 11 / 12 quit I keep getting the error ORA...

I have a temp table where I am trying to dump text from a flat file so i can query it out and work with it. When sqlldr is ran it finishes its session and then clear the table by default. I wanted to run a query afterwards but couldn't. Is there anyway to :: 1.Run sqlldr to dump data into...

Can perl use a cursor to access oracle databases on unix systems? I need to learn how to do two things quickly with perl: 1.Read an external text file 2.Parse and pass data to another file Are there any examples I could work with? Greg

I created a program that creates a directory that references a text file as if it were a database. Well, it works fine. I moved it to another server created all the proper directories and text files and these errors popped. ORA-29913 Error in executing ODCIEXTTABLEOPEN callout ORA-29400 data...

I am trying to read text from a text file and need to use a different directory. In my reading I found how to do it using the init.ora file in the UNIX OS. Unfortunately my DBA is being rebellious and not allowing me to use the init.ora method because of having to bounce the dbase AND the fact...

How do I convert a 16 bit to 32 bit field and vice versa. Is it base 2 numbers? Also finding a point in a volume, can PL/SQL perform something like that. Greg

I am running a FOR loop For I IN c_id_map.first..c_id_map.last loop There is data retrieved from the c_id_map table structure that is declared in this structure. Not actually in the Schema. So it works as a user defined type does in other languages. There are only 2 records to be looked at...

I found RawtoHex and HextoRaw functions, but are there any other functions to do other number system conversion?