OK. Now I understand the status better. -- Dan
________________________________ From: [email protected] [[email protected]] on behalf of Al'ona Furmanchuk [[email protected]] Sent: Wednesday, December 14, 2016 10:03 AM To: <[email protected]>; Dan Connolly; [email protected]; Brittany Zschoche; Nathan Graham; Charon Gladfelter Subject: Re: [gpc-informatics] #546: Oracle port of NextDextractionCode_12.1.16.sql Sorry, could not provide logs since i do not have PCORNET in oracle formats. I downloaded oracle database express edition 11 g and sql developer. For this project I created small tables with couple of lines in them. Was testing commands on them one by one, to be sure they are working in oracle. Please, add `on commit preserve rows' whenever you think it is needed. Differently from transact-sql version, this one is no means final full proof code since I am using oracle for less than one week now. Will appreciate help from you to make sure code is running fine on your database. On Wed, Dec 14, 2016 at 9:02 AM, GPC Informatics <[email protected]<mailto:[email protected]>> wrote: #546: Oracle port of NextDextractionCode_12.1.16.sql --------------------------+--------------------------- Reporter: dconnolly | Owner: afurmanchuck Type: task | Status: assigned Priority: major | Milestone: next-d Component: data-sharing | Resolution: Keywords: | Blocked By: Blocking: 545 | --------------------------+--------------------------- Comment (by dconnolly): I don't see how this code could work. I don't recognize `capricorn.dbo.ENCOUNTER` as Oracle syntax for a table reference. And the temporary tables don't have `on commit preserve rows`. Do you have a log of running the code that I could look at? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/546#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics -- Al’ona Furmanchuk, Ph.D. Research Associate Department of Electrical Engineering and Computer Science Northwestern University 2145 Sheridan Road, Tech L359 Evanston, IL 60208 Web: http://furmanchuk.com/ E-mail: [email protected]<mailto:[email protected]> Phone: 847-467-2299
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
