DSXchange

No.

I know! I'll just write a bot that crawls the site and posts 'Time to mark your post as Resolved!' messages to any open issue I can find. I'll be caught up in no time.

If you absolutely need to use them, the 'best approach' can depend on if you need to know the sequence value or not. If you do, then an OCI reference lookup that selects 'seqname.nextval from dual'. Of course, these are singleton lookups, fired once per record processed and probably across a network...

kumar_s wrote:Ray hits 18K in his usual pace.
Still maintaining ~ 2*Craig's post.
Thanks for your time.

And thanks for pointing that out.

[sigh] Because that particular function is built to connect to the same server your Project resides on. The XML Meta Data Importer is a separate client tool the Manager spawns which only has connectivity to your local PC. Or, if you can find a syntax that works, there is the 'Open From the Web' file...

Actually, there is a 256000 character limit for log messages. When I capture a large amount of output from a script, for example, it will dump quite a bit of it into the log and then show: ...[Message truncated to 256000 characters, actual length was 298659 characters]... One such example pulled fro...

It's about the service, that's what the user request is all about. And without it running, you can't switch.

Along with his little brother, 'u'.

parvathi wrote:I have executed the command given above. iam not able to echo the value.

You have executed this where? Anything declared via the Administrator will be available when jobs are run. If you are 'Test'ing it via a routine or 'executing' this in some other fashion...

Mohanram wrote:Can we call procedure (for Truncating Table )from OraBulk Stage?

No. You'll need to find some other place to do that, like a Stored Procedure stage. Or switch it to 'Manual' mode and tweak the generated control file before you launch sqlldr.

You two need to learn how to quote.

How about you explain exactly how you are fetching these encrypted values that gets you the unencrypted values? And then explain what you are doing with them afterwards? More than just 'getting' and 'writing' please. Rather than all this, perhaps you should just not record any 'encrypted' values? Or...

"Symbolic" = "wildcard" I do believe.

Unfortunately, no. A search will reveal one or two other threads with people having this issue on Windows servers with the 'AT' command, but no resolutions. So far.

First make sure it is working with your changes. Indexes just make it work faster, they are not needed to make it work. Last thing we would need is the impression that indexing is causing it to break.

Ray has clarified the index creation situation.