DSXchange

In order to answer that you'd need to do two things:

1. Determine where oraoci9.dll lives
2. Make sure that directory is in your PATH

Have you checked the documentation, specifically the Connectivity Guide for Oracle Databases pdf? It is typically all spelled out there. I know what needs to be set for a UNIX server but for Windows, not so much. I'd suggest checking the System variables section of the Environment Variables found un...

Looks like you figured that part out. :wink: For #1, isn't there more to the error message? Usually it's followed by something like "The specified module could not be found" that notes the problem. It would also be helpful to know which "Oracle stage" you are having the issue wit...

Why is this marked as Resolved? Did you figure out your issue?

Verify for us that your job's parameter name exactly matches what you are using on the command line - including case.

Too many "-param"s in there.

Hmmm... from what I recall, IsValid() supports both a 'type' (decimal,date,etc) and a 'format' so sure thought you could pass in whatever date format string it should use for the check. Got no way to prove that other than the docs, unfortunately.

It would help if you have an actual ORA error to post, do you? Nothing in your first post falls into the error camp.

Ah, the wonders of UniVerse internals. :wink: As others have noted, some of the topics you've chosen aren't simple, one-or-two-post subjects. There are advanced classes that get into them or they come with literally years of experience that people like Ray and Kim Duke amongst others here have. For ...

That would be a "vertical pivot" and there's no stage to automate that for you. However, an exact search here for vertical pivot will reveal... well, lots of post telling you to search and the occassional one that explains your options. Short version, two main options: 1) Do the assembly i...

IsValid() is expecting a string and can tell you if the characters in the string represent a valid date or not. If it does then convert it.

Seriously? Sorry but first you said there's no criteria and then you stated the criteria it uses. Wasn't trying to bust anyone's chops, it just tickled my funny bone a bit. And FWIW, that behaviour matches what an Informatica lookup does when its selection criteria is set to "First".

LOL... that too.

ps. Just post your questions, please don't send it out via private messaging as well. There's no need and it just upsets the natives.

First step is always to move it from "unknown character" to known by determining the decimal or hex value of the character. A hex editor would make that simple or you can check your man page for "od" to see what your switches are to output the character in something besides octal...