Following up on my question of last week on the failed UPDATE queries for
changing handles on an Oracle database, this is what happened.
Stuart Lewis suggested that the failing query was this:
UPDATE metadatavalue SET text_value= (SELECT 'http://hdl.handle.net/' || handle
FROM handle WHERE handle.resource_id=item_id AND
handle.resource_type_id=2) WHERE text_value LIKE 'http://hdl.handle.net/%';
When I ran that in the Oracle SQL Developer application, I got an error
something like "no statement at cursor." I simply deleted the semicolon and ran:
UPDATE metadatavalue SET text_value= (SELECT 'http://hdl.handle.net/' || handle
FROM handle WHERE handle.resource_id=item_id AND
handle.resource_type_id=2) WHERE text_value LIKE 'http://hdl.handle.net/%'
Which worked. Could that really be all that it is?
_____________________________________
Tom McGee
Senior Digital Media Specialist
Seton Hall University
400 South Orange Ave., South Orange, NJ 07079
973.275.2992
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
