当前位置: 动力学知识库 > 问答 > 编程问答 >

stored procedures - Schedule "string too long for attribute" query in Oracle

问题描述:

I have several long (lines of SQL) Oracle queries that currently repeat daily as an SSIS package. The queries are all Create Table AS Select... with a bunch of joins, where clauses and selects.

The SSIS runs fine, but slow, due to nature of the linked server. Runs fine in SQL Developer. I am trying to move all queries into Oracle as scheduled jobs, but I am running into the "String value too long for attribute "job action" ORA16612. How to proceed? Tried to make a procedure of it using "Create Procedure...Begin.... execute immediate" but I get the same error on length.

分享给朋友:
您可能感兴趣的文章:
随机阅读: