Can we give call a sequence in close command of a lookup ora

[skaruturi]

We are calling a function to create a sequence in close command.In our environment it is creating the sequence and job isrunning fine.When we dsx form and change the environment,The job is getting aborted saying sequence is not created

[chulett]

When we dsx form and change the environment,

How about you rephrase this bit? Not really sure what you mean there.

[skaruturi]

When we take dsx form of the job and inport in other environmnerts,the job is getting aborted saying .'Sequence is not created'

[chulett]

And you are positive that this Oracle sequence exists in this other database and your user has all the grants it needs to it?

[meena]

Hi Skaruturi,
It is .dsx file, not dsx form.Can you be clear with what you are doing and about the job).

When we take dsx form of the job and inport in other environmnerts,the job is getting aborted saying .'Sequence is not created'

[ray.wurlod]

My guess is that the OP is executing a stored procedure or some other command from the Close command of an Oracle Enterprise stage, and that this sp/command tries to invoke a sequence. The message suggests that the sequence of that name is not accessible from the instance specified by the job parameters when a non-default value is supplied. This comes as no surprise really; it suggests that the sequence has not been created in the other instance, or that someone got its name wrong. Check using some other client, such as Oracle Enterprise Manager or TOAD.