A new topic, 'Problem with Custom SQL ', has been made on a board you are
watching.
You can see it at
http://liquibase.org/forum/index.php?topic=642.new#new
The text of the topic is shown below:
I know... me again :), but I'm dealing with this thing and I can't make it
work, but it shoud drop the materialized view if it exists:
Code:
<changeSet id="mview-creation-test" author="alexis" runOnChange="true">
<!-- Simulate a CREATE OR REPLACE MVIEW with a drop if exits and the
create -->
<sql splitStatements="false">
BEGIN
EXECUTE IMMEDIATE 'DROP MATERIALIZED VIEW MY_MVIEW';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -12003 THEN
RAISE;
END IF;
END;
</sql>
<sqlFile path="my_mview.sql" />
<rollback>
<sql>DROP MATERIALIZED VIEW MY_VIEW</sql>
</rollback>
</changeSet>
basically this part gives me always an error and I don't know why, because if I
run it normaly it works well:
BEGIN
EXECUTE IMMEDIATE 'DROP MATERIALIZED VIEW MY_MVIEW';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -12003 THEN
RAISE;
END IF;
END;
is similar to the example given in the sql custom liquibase manual
Thanks,
Alexis.
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The Liquibase Community Forum Team.------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
