Category Archives: SQL

PL/SQL cryptic error messages

Posted on 17 May, 2007 by Simeon

I have just found (oh thank you Google and the Oracle forums) the solution to my PL/SQL error CA_ADD_DESIGN_1 (28,5): PL/SQL: ORA-01747: invalid user.table.column, table.column, or column specification My first problem was which line does the 28 refer to, as … Continue reading →

Posted in Programming, SQL | Leave a comment

SSIS Experimenting

Posted on 5 October, 2005 by Simeon

For the last week (or unofficially last two weeks) I’ve been using SQL Server Integration Services to build the import process for the daily data exchange we have with our customers. The system is used to aggregate a fragmented market … Continue reading →

Posted in SQL | Comments Off