Recent content by dkwong

I have two USB game pads that I use. Sometimes only one of the controllers are recognized. If I go into Control Panel -Gaming Options, I won't see the second controller listed. If I try to find it, it won't detect anything. After I reboot, sometimes it will recognize the second controller...

Bored, Thanks for replying! After a year I still hadn't found the answer. Do you know if there's a solution for Windows ME?

This procedure is written in PL/SQL, not SQL*Plus. There error only says that the memo_field_tx "is not a valid integer value".

This is a test procedure to parse out lines of a memo and output it. I'm not sure why it doesn't work. It complains that it doesn't like the value assigned to the memo_field_tx variable. The error is : 'FIRST LINE SECOND LINE THIRD & LAST LINE' is not a valid integer value PROCEDURE...

Does anybody know if there is a function in Oracle equivalent that can parse out lines in a memo field? I want to take in a field that contains multiple lines separated by line breaks and return a specific line or return the number of lines in the field. What's the best way to do this? i.e...

Does anybody know if there is a function in Oracle equivalent to the MLINE and MEMLINES dBase functions? These functions take in a field that contains multiple lines separated by line breaks and will return a specific line (MLINE) or return the number of lines in the field (MEMLINES)...

Another bit of info, the execution fails at: act_file := utl_file.FOPEN('c:\','spooltest.txt','W');

Update: I implemented the code above in PL/SQL using the UTL_FILE package, but it's still not working. Any ideas? CREATE OR REPLACE PROCEDURE PR_EXPORT_INFOTRAC_APPO IS extract_file UTL_FILE.FILE_TYPE; CURSOR pr_header_crsr IS SELECT RPAD(pr_number_tx,9,' ') pr_number_tx...

I have the following sql script that successfully spools the result of a select statement into a textfile but I'm having trouble putting it into a stored procedure. Is there different syntax for the following in PL/SQL? How does it fit in a begin end block? [code] SET ECHO OFF SET HEADING...

Thanks, jee!

This function is used in a dBase program. I cannot find it in any language reference and I don't think it's a user-defined function. Any ideas?

Could somebody tell me what the STR function does? e.g. STR(lineItem,2,0 STR(purreq->totalCost,12,2) Is there an equivalent function in Oracle PL/SQL?

Is there a built-in function in PL/SQL to do the following or should I just write a function: I want to format a dollar amount field. If the field value has no decimal places, format the number to have two decimal places. If it has 1 decimal place, add a zero after it to have two decimal...

Thanks! It worked after I added the semi-colon to RETURN return_value and declared return_value in the declaration section.

Why can I not assign a SQL statement to a variable? Thanks! CREATE OR REPLACE FUNCTION Lookup(id_no IN NUMBER, table_name IN VARCHAR2) RETURN VARCHAR2 IS BEGIN IF table_name = "vendor" THEN return_value := (SELECT vendor_number_tx FROM table_name WHERE vendor_id_no =...