Post reply

Funky error msg

  • October 23, 2008 at 10:56 am

    #383205

    I am getting this when trying to run a script to create a procedure but, funny thing is, I am not using varchar(25) anywhere in the script.

    [font="Courier New"]Msg 2715, Level 16, State 7, Server DELL755-3, Line 14

    Column, parameter, or variable #5: Cannot find data type varchar(25).

    [/font]

    Any ideas?

    Oh, BTW, we ARE using varchar(25) in numerous other places with no problems.

    Columns defined as varchar(25) parameters to other procedures set to varchar(25), etc...

  • October 23, 2008 at 11:00 am

    #888752

    kewl to get a wierd error....can you paste lines 13,14,15 from your script so we can see what line 14 might be doing to cause the error?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 23, 2008 at 11:08 am

    #888757

    My bad, it wasn't the create procedure part of the script doing it but a real bonehead

    definition of [varchar(25)] in a create table. DUH!!!

    I forgot that the error message comes from the system parsing the code before it runs it so the message would be added to my error listing before the code that caused it.

    BTW, I am using osql with an output log.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply