986006 wrote:You obviously haven't read the FAQ, or at least you haven't bothered doing what it asks. Help us to help you.
Thanks for the hints up... I have updated my post... As I post the test procedure...it is about the exact the same as the insert query... Every time, the insert would actually insert data into the table but every time I run the test procedure, nothing gets inserted in... It sounds unbelievable but it happens... Thanks
tags. At the very least post the *exact* SQL or PL/SQL you are trying to run: what you've posted isn't even valid SQL.
This is bad for a couple of reasons. First, forcing lower case objects using the double quotes is a bit of a pain. It is generally better and easier to store objects in the database in standard upper case to avoid this. You may not have a choice in the matter but this is not a desirable situation.
FROM "table 1"@Pmo.World Cr,