Error when using function CDbl in Script Editor

623479 Nov 12, 2008 9:24 PM

Hello,

While using the CDbl function in the Script Editor I am getting the following error:

Error - 13 - Type mismatch: 'CDbl' at Line 24

The reason I am trying to use CDbl is that I get another error while importing the data from a .CSV file

Import Error = TC - [Amount=NN|http://forums.oracle.com/forums/] 01-000-1030,Cash in Bank - Payroll,837.83,0.00,"1,569.50",0.00

Any suggestions would be appreciated.

-Tony

1. Re: Error when using function CDbl in Script Editor

631379 Nov 12, 2008 10:59 PM (in response to 623479)

I think you need to remove the quotes from the number. The quotes would tell the system that your number is a text.
Like Show 0 Likes(0)

Actions
2. Re: Error when using function CDbl in Script Editor

623479 Nov 12, 2008 11:12 PM (in response to 631379)

Hi Kelley,

Thanks for that infomation. Unfortunately, I recieve the Type Mismatch: 'CDbl' error prior to the .CSV file being read. Basically I add the CDbl function press "Save" and "Run" and that's when i get the error.

My question is that why can't I use the CDbl function.

Thanks
Tony
Like Show 0 Likes(0)

Actions
3. Re: Error when using function CDbl in Script Editor

657263 Nov 13, 2008 7:50 PM (in response to 623479)

Tony,

Please keep in mind that pressing 'Save' and then 'Run' without using the script in a workflow is sometimes not a valid test. As the scripting generally created inside of FDM needs to be part of a workflow and certain variables/functions are passed when that workflow is executed as a whole.

Hopefully this helps...
Like Show 0 Likes(0)

Actions
4. Re: Error when using function CDbl in Script Editor

623479 Nov 13, 2008 9:15 PM (in response to 657263)

Sure does make sense. I kind of figured that based on my trial and error.

Thanks again!
Tony
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.