Recent content by Wrinn

Dear, As I tested, the maximum exit code value is just 256. (Maybe I'm wrong) if I code as ... exit 3010 I will retrieve the value 194 from running this script. I don't know why. Does anyone know how to exit with code number 4 digits? Please advise. Regards,

Here are some errors from compiling the Original Form ASXINWKB.fmb: 1. CALCULATE_USER_XRATE must be declared 2. wrong number or types of arguments in call to 'AP_CANCEL_SINGLE_INVOICE' 3. component 'CHECK_DIFF_DIST_SEGMENTS' must be declared 4. wrong number or types of arguments in call to...

Dear, I'm trying ro import jounals from the external system and would like to import them into Oracle GL by using 'Journal Import' program. But I wonder that when I try to use that program, it informs that 'FRM-40508: ORACLE error: unable to INSERT record' ORA-00904: invalid column name. As I...

Dear, I'd like to use the 'decode' or 'nvl' command for long datatype. But the system informs me that 'ORA-00997: illegal use of LONG datatype'. Does anyone have any ideas? Thanks,

Dear, I got a report program which is created by Developer Report version 2.5. I'm wondering that if it can be executed on Developer Report 6i. Does anyone know please advice me. Thnx :)

Dear, I'm trying to connect the Oracle Application 11i. But system informed me the error message that 'java.lang.ClassFormatError: Duplicate name'. Does anyone have any ideas? Please advice me. Regards,

Dear, when I tried to create a new summary table, the system informed that 'The summary table owner requires explicit select access to the details table' Does anyone know the reason? Please advice me. Regards,

thnx>>> :) your advices are very useful

Thank you so much. Anyway, could u please give me some samples? thnx again,

Dear, I've created one batch probram(contains set of dos commands). Is it possible to call this progrm from the DTS package? Does anyone know how to do it? please let me know. Thnx in advance,

Dear, I've created a DTS package to transfer data. For each step of pakage I'd like to catch up the error message and write it into one file. I've tried to add one active script after each step (on failure). I coded as below ... Set Myfile = fso.CreateTextFile("C:\Test.text",True)...

Dear, Is it possible to write the flexible information into the 'message' property of 'DTSSendMailTask' object? Does anyone know? Please tell me in details how to do it. Thnx in advance

I'd like to set the 'mail' profile' on the PC.

Dear, As I know, If i would like to send mail by using the 'Send Mail Task' package, I have to set up the 'mail profile' first, right? Unfortunately,I'm short in idea about setting up the 'mail profile'. Does anyone can give me the details of setting the 'mail profile'? Any advices or...

Dear, I would like to import Flat file into MS database by using DTS (Data Transfer Services). But my flat filename is flexible, its name depends on current date: such as F051101.dat. Does anyone know how to set flexible imported filename? Regards,