Member since
09-01-2016
27
Posts
4
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5204 | 12-28-2016 09:54 AM | |
2258 | 09-19-2016 07:06 AM |
11-09-2017
08:59 PM
Thanks for the feedback. We
used both QueryDatabaseTable and ExecuteSQL. The CLOB is large and our
quick and dirty workaround is to create a view but I had to limit the
column to 1000 (see below) as the processors still had an error with the
max 4000 that Oracle could handle (converting a CLOB).
DBMS_LOB.SUBSTR(TEXT_DOC, 1000, 1)
... View more
09-05-2017
07:56 AM
@David Sheard @Saisubramaniam Gopalakrishnan Public IPv4 addresses enable communication over the Internet, while private IPv4 addresses enable communication within the network of the instance (either EC2-Classic or a VPC) Can you try using the private IP's in the /etc/hosts on all the hosts and retry. 1x2.31.83.454 ip-1xx-x1-2x-1xx.ap.southeast-2.compute.internal
1x2.91.27.784 ip-2xx-x1-2x-1xx.ap.southeast-2.compute.internal Please let me know
... View more
09-19-2016
07:06 AM
1 Kudo
It seems it isn't happy with using a function such as max 😞 Work around (schema and table name withheld): select * from
(select nextval from <schema>.<table_name> order by nextval desc)
where rownum=1
... View more